Copy of auto_increment column

[jggretton]

Hello, i've got an `id` column which auto_increments, but I also would like another column initially set to the same number as `id`.

Is this a sensible way of doing this on mySQL 4.0.26:

"INSERT INTO `bla` ( `id` , `id2`, `text`) VALUES ('', '', 'Bob'); UPDATE `bla` SET `id2`=LAST_INSERT_ID( ) WHERE id=LAST_INSERT_ID( );"

And send it as one query from php?

Thank you for any help you can give me,

James

 

[TonyGroves]

I don't know if PHP allows SQL statements to be strung together like that. But whether it does or not, those statements would seem to be fine.

 

[guelphdad]

I believe in PHP you would still have to send it as two separate queries. You won't have to worry about the value of the insert id changing though since it is independant of other users inserting rows. I believe in PHP though you use mysql_insert_id() rather than last_insert_id().

 

[jggretton]

Fantastic, very pleased i don't have to worry about the insert id changing. Thanks to both of you for your help!

James