Fix auto increment mysql
database, mysql, sql
Solution
ALTER TABLE theTableInQuestion AUTO_INCREMENT=1234
Problem
Possible Duplicate: MySQL: Reorder/Reset auto increment primary key? I have an auto increment field in my sql, by accident i deleted something now my tables are off because the auto increment number jumped. I forgot the exact sql command but i remember there was an Select table set auto increment='whatever' i just forgot the syntax, can anyone help?