sql,query
At 0:07 +1000 10/17/02, Alan McDonald wrote: >Peter, >Thanks you - I looked up Insert_ID() in the manual... >Page 171-172 >If I insert into person but before I insert into short, someone else inserts >into person, surely my inserts into shirt will have their last Insert_ID()? Surely you've tried it for yourself. So, when you run a test scenario to check out what happens ... what happens? > >Do you know if this is true only in the same connection context only? Or >does insert_id() return another connections last insert? > >Alan No other client can change the value that LAST_INSERT_ID() returns to *you*. It's designed to solve the very problem about which you are concerned. --------------------------------------------------------------------- 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