bonjour,
Le mardi 03 ao�t 2004, Ralf Becker a �crit...
> >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 ...
I read that:
The current DEFAULT SERIAL value can be requested using
<table_name>.CURRVAL where <table_name> is the name of the table that
contains the column defined as DEFAULT SERIAL.
For the number generator generated by DEFAULT SERIAL, this is an
equivalent to the @@IDENTITY or LAST_INSERT_ID() functionality of other
database systems.
So I "suppose" it's session dependant.
But it is easy to verify with two opened clients.
--
jm
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
