[drupal-devel] LOCK vs. SELECT FOR UPDATE

Moshe Weitzman weitzman at tejasa.com
Thu Sep 29 11:39:05 UTC 2005

Karoly Negyesi wrote:
>>> 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.

Do successive requests from the same web server reuse the same connection?

More information about the drupal-devel mailing list