Bug #74888 LAST_INSERT_ID() is giving wrong result
Submitted: 17 Nov 2014 4:49 Modified: 17 Nov 2014 8:41
Reporter: Ashif Anwar Email Updates:
Status: Unsupported Impact on me:
Category:MySQL Server Severity:S3 (Non-critical)
Version:MySQL Server 5.0 OS:Windows
Assigned to: CPU Architecture:Any

[17 Nov 2014 4:49] Ashif Anwar
when I use LAST_INSERT_ID() in my mysql table to get the recent generated auto increment column. it is giving me the wrong result

How to repeat:
create a table with id as auto increment column and try to get the recent entry using last_insert_id()
[17 Nov 2014 8:41] MySQL Verification Team
Thank you for taking the time to report a problem.  Unfortunately active development for MySQL Database Server version 5.0 has ended.

Please download a new version from http://www.mysql.com/downloads/

If you are able to reproduce the bug with one of the latest versions, please change the version on this bug report to the version you tested and change the status back to "Open".  Again, thank you for your continued support of MySQL.