Ralf Becker wrote: > > Hi Jean-Michel, > > thanks for the quick answer. > > Jean-Michel OLTRA schrieb: > > Le mardi 03 ao�t 2004, Ralf Becker a �crit... > >>I can't use a sequenze and retrive the value before I insert the new > >>row, as I port an existing (big) applications, which uses this > >>mysql'lish get_last_insert_id all over the place. > > > > SELECT THETABLE.CURRVAL FROM DUAL > > and fetch the value. > > What happens, if an other concurrent user insert a new row in the > meantime? Is this garantied to deliver "my" insert-id? It doesnt look > alike to me ... >
it will deliver YOUR insert-id, no matter what other user will do. Elke SAP Labs Berlin > Ralf > > > -- > MaxDB Discussion Mailing List > For list archives: http://lists.mysql.com/maxdb > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
