Re: LAST_INSERT_ID() returns different values on different connections

2003-06-24 Thread Paul DuBois
At 16:02 +0300 6/17/03, Baris Akin wrote: Hello, I try to get last inserted autoincrement record ID on table with LAST_INSERT_ID() function (SELECT LAST_INSERT_ID() FROM TABLE). Every connection returns it's own last inserted ID not actual ID. Is this a bug? Also it returns more than one

LAST_INSERT_ID() returns different values on different connections

2003-06-17 Thread Baris Akin
Hello, I try to get last inserted autoincrement record ID on table with LAST_INSERT_ID() function (SELECT LAST_INSERT_ID() FROM TABLE). Every connection returns it's own last inserted ID not actual ID. Is this a bug? Also it returns more than one record (20 rows). Thanks Baris AKIN

Re: LAST_INSERT_ID() returns different values on different connections

2003-06-17 Thread Fred van Engen
On Tue, Jun 17, 2003 at 04:02:46PM +0300, Baris Akin wrote: I try to get last inserted autoincrement record ID on table with LAST_INSERT_ID() function (SELECT LAST_INSERT_ID() FROM TABLE). Every connection returns it's own last inserted ID not actual ID. Is this a bug? Also it returns more

Re: LAST_INSERT_ID() returns different values on different connections

2003-06-17 Thread Victoria Reznichenko
Baris Akin [EMAIL PROTECTED] wrote: LAST_INSERT_ID() function (SELECT LAST_INSERT_ID() FROM TABLE). Every connection returns it's own last inserted ID not actual ID. Is this a bug? No. LAST_INSERT_ID() works per-connection. It returns the last inserted auto_increment value from current