INSERT并设置一个字段以复制新插入的ID

Question

Is it possible to INSERT a row, and simultaneously set one of the fields to contain the inserted row's ID? (the "self" id)

I'm trying to avoid using multiple queries if possible (it would be 3 queries in total otherwhise)

Something like this (but probably not):

INSERT INTO thetable (email, phone, activationkey) VALUES ($email, $phone, CONCAT(THIS_NEW_ID, md5($activation) )

Answer 1

Why would you want to store duplicated data?

You could change your table structure and just run:

INSERT INTO thetable (email, phone, activation_suffix) 
     VALUES ($email, $phone, md5($activation))

And then you have all the data you need.

You can always concat when you query the table:

SELECT CONCAT(id, activation_suffix) activationkey
  FROM thetable
 WHERE ...

UPDATE

On second thoughts, do you really need the id as part of the activationkey?

I wouldn't want to give any user the id for their record in my table unless it is hashed/encrypted.