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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
