'connection ID' below should be 'last insert id'. Sorry, it's 2am here and I'm fresh out of coffee. BTW the information you want is here: http://www.mysql.com/doc/en/Information_functions.html#IDX1409
"The last ID that was generated is maintained in the server on a per-connection basis. This means the value the function returns to a given client is the most recent AUTO_INCREMENT value generated by that client. The value cannot be affected by other clients, even if they generate AUTO_INCREMENT values of their own. This behavior ensures that you can retrieve your own ID without concern for the activity of other clients, and without the need for locks or transactions." On Thu, 2004-02-19 at 09:26, Mark Maunder wrote: > The two simultaneous insert statements will be have separate connections > to the database and last_insert_id() is connection specific. So if > you're running apache, and you're worried about two different apache > child processes getting the same connection ID, don't. Because those two > children will have separate connections to the DB. > > If you're forking or threading and using the same connection, it becomes > a bit more complex. > > Mark. > > On Thu, 2004-02-19 at 09:17, Binay wrote: > > Hi > > > > I have a php script which insert a row in one of my table. Now i want the > > auto_generated id produced by this insert query. I know i can use mysql_insert_id > > function to fetch that auto_generated id. But my question is say two or more > > person visiting the same page/script causes a insert operation in the table at the > > same time. so there are chances of getting wrong auto_generated ids for different > > visitors. why am i saying this can be clear from below example. > > > > Say one insert operation is in the progress and by the time control switches/call > > to mysql_insert_id function another insert operation starts .. so ultimately > > mysql_insert_id will fetch 2nd insert operation id which should not be the case. > > How to resolve this case?? > > > > Thanks > > > > Binay -- Mark Maunder <[EMAIL PROTECTED]> ZipTree.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
