* James Montebello > Of course, if you do LAST_INSERT_ID, then try to use the value > while someone else is doing an insert, you're in the same boat. > Neither method is reliable without a lock.
This is not correct. The LAST_INSERT_ID() function return the last inserted auto increment key for _this_ connection... this is fairly easy to test: just open two different connections to the same mysql db, insert some records into the same table in both consoles, and check last_insert_id() in both... repeat until satisfied :o) -- Roger --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
