[drupal-devel] LOCK vs. SELECT FOR UPDATE

[Karoly Negyesi]

>> 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.