In this post, I am sharing a script to find last updated AUTO_INCREMENT of a MySQL Table. We use LAST_INSERT_ID() function to get the last updated AUTO_INCREMENT value for the particular running session. We can use this with any code block and it will return last updated AUTO_INCREMENT value of the last executed statement. Database […]

I'm Anvesh Patel, a Database Engineer certified by Oracle and IBM. I'm working as a Database Architect, Database Optimizer, Database Administrator, Database Developer. Providing the best articles and solutions for different problems in the best manner through my blogs is my passion. I have more than six years of experience with various RDBMS products like MSSQL Server, PostgreSQL, MySQL, Greenplum and currently learning and doing research on BIGData and NoSQL technology. -- Hyderabad, India.