Question about persistent DB connection, the LAST_INSERT_ID

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



HI, the question is whether there is any chance the LAST_INSERT_ID
could be wrong during inserting with a persistent DB connection?

For example, instance [AA] of a script insert one row with an
auto-increment field, and retrieve the LAST_INSERT_ID after the
operation, at the same time, there is another instance [BB] of the
same script doing the same thing. Giving that the sequence happens as
indicated below for reason that [AA] somehow runs a little slower
after inserting.

[AA] insert
[BB] insert
[BB] select the LAST_INSERT_ID (IDB)
[AA] select the LAST_INSERT_ID (IDA)

Will the [AA] still have the correct LAST_INSERT_ID when the DB
connection is a persistent one?

Thanks for help.
--
If you have a minute, please visit http://www.cchere.com

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux