In the last episode (Apr 19), Robert Mark Bram said:
> 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?
Returns the last automatically generated value that was
inserted into an AUTO_INCREMENT column. See section 18.104.22.168
The last ID that was generated is maintained in the server on a
per-connection basis. It will not be changed by another client.