MySQL: how to use the result of one INSERT in another INSERT

Question

I need to use the received key of one insert, in another insert. Is this possible with MySQL?

+3

stevebot Mar 08 '11 at 16:10

1 answer

Shakti singh · Accepted Answer · 2011-03-08T16:13:13+0000

mysql_insert_id returns the id of the last inserted record, you can use this

Gets the identifier generated for the AUTO_INCREMENT column by the previous request (usually INSERT).