MySQL - Next Auto-Increment
April 25th, 2008Simple - in a mysql prompt, type this:
SHOW TABLE STATUS LIKE 'tablename';
Where the tablename is the table you need to find the next auto_increment value. It should be the 9th value in the results.
Leave a Reply
You must be logged in to post a comment.