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

Markus

The MySQL manual states:

Quote:

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

Quote:

Originally Posted by Markus

The MySQL manual states:
I wonder what is considered a 'client'. Is that simply just different connections to the database?

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

Markus

Quote:

Originally Posted by mwasif

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

Thanks for the clarification!

dlite922

That's what I just said! :)

j/k

Dan

Markus

Quote:

Originally Posted by dlite922

That's what I just said! :)

j/k

Dan

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

;D

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

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

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

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

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

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

Similar MySQL Database bytes

/bytes/development

/bytes/it

/bytes/about