What is considered 'multiple clients' - LAST_INSERT_ID().

[Markus]

The MySQL manual states:

Using LAST_INSERT_ID() and AUTO_INCREMENT columns simultaneously from multiple clients is perfectly valid. Each client will receive the last inserted ID for the last statement that client executed.

I wonder what is considered a 'client'. Is that simply just different connections to the database?

[dlite922]

Well don't know but it seems to work, so IMHO it's same to assume that's what a client means.

If it wasn't true if two people were using the app and both say...new users. the first user wouldn't get the first user's auto_increment ID.


Dan

[mwasif]

@Markus
Yes, each connection to MySQL will be considered a separate client.

[Markus]

@mwasif
Thanks for the clarification!

[dlite922]

That's what I just said! :)

j/k



Dan

[Markus]

@dlite922
I was thanking both of you, I just couldn't reply to you both (without more clicking).

;D