last_insert_id() with multiple users

[Robert Mark Bram]

Howdy All!

This is not mine, but a comment I found in the manual that I would very much
like to see answered.


How does the combination of auto_increment and last_insert_id() work in a
concurrent situation:
User1 inserts with auto_increment, and for some reason is delayed with the
last_insert_id() call.
User2 inserts with auto_increment.
User2 calls last_insert_id()
User1 finally calls last_insert_id()

Which id does User1 get?
Which id does User2 get?

http://www.mysql.com/doc/en/example-AUTO_INCREMENT.html


Any helpful answers would by much appreciated!

Rob
:)
:->
:-}