Question about persistent DB connection, the LAST_INSERT_ID
am 17.01.2007 01:17:13 von cchereTieShouHI, 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