[drupal-devel] LOCK vs. SELECT FOR UPDATE

[Gerhard Killesreiter]

On Thu, 29 Sep 2005, Karoly Negyesi wrote:

> I think we should use autoincrement/serial and have a db_last_id function
> (mysql_insert_id, select currval, lastInsertId in PDO etc.). This would
> make Drupal code actually shorter and simpler (a very little bit).


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.

See here for some warnings:
http://de.php.net/manual/en/function.mysql-insert-id.php

Cheers,
	Gerhard