[drupal-devel] LOCK vs. SELECT FOR UPDATE

Karoly Negyesi karoly at negyesi.net
Thu Sep 29 08:48:52 UTC 2005

>> I think that I do now recall why we are looking up the next ID first: If
>> we use mysql_insert_id we risk not getting the right ID.

Per mysql doc:

"For LAST_INSERT_ID(), the most recently generated ID is maintained in the  
server on a per-connection basis. It is not changed by another client."

I fail to see how could we no get the right ID.

More information about the drupal-devel mailing list