MySQL - Next Auto-Increment
Friday, 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.