LAST_INSERT_ID() returns different values on different connections

[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

Istanbul/TURKEY