更可靠的LAST_INSERT_ID解决方案[重复]

Question

This question already has an answer here:

• Easy mysql question regarding primary keys and an insert 4 answers

so I want to link two tables with a common column "messageID". so first I insert into table 1 to get the Auto incremented id, then take that ID with LAST_INSERT_ID function and give that as the id for table 2:

$db->("INSERT INTO table_1 VALUES('','$message')");
$db->("INSERT INTO table_2 VALUES(LAST_INSERT_ID(),'$message');

but here's my concern, there might be two users running this script simultaneously, so in the few milliseconds between the two queries exicuting the LAST_INSERT_ID could have changed, so now the two id's are different. Is there any way I can prevent this possibility. I know it is not possible to insert into two tables with one query, which was my first thoughts. Any ideas much appreciated. Thank you

</div>

Answer 1

The LAST_INSERT_ID is local to the connection session, so it will not conflict with a different user making an insert.