"mel list_php" <[EMAIL PROTECTED]> wrote on 15/02/2005 10:18:55:
> Hi! > > I have a database where several users can connect and input data. > > I managed to have my insert queries as atomic, but I was wondering about one > special case: I make one insert, and retrieve the last id inserted by mysql > because I need to update an other table with that id. > > - if one user inserts and retrieves the id, but between both one other has > inserted something the id returned will be the right one? > > - or do I have to lock my table, execute the query, retrieve the id, unlock > the table? > > - is there a way to make an atomic query with this that would avoid me to > use locks? last_insert_id is on a per-connection basis i.e. it gives the last id inserted using that particular connection. Therefore you will always get the most recent ID that you inserted, not the most recent that anyone inserted. I think, therefore, that the natural behaviour is what you want. Alec -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]