MYSQL - autoincrement - set next value?

[Tea_J]

MySQL

How does one reset the next autoincrement value?

Tea

[sfullman]

http://dev.mysql.com/doc/mysql/en/TRUNCATE.html

Note this may not work for your mysql version and if you use phpMyAdmin, I also note when you empty a table it uses the command TRUNCATE at least for my version 4.01.

Sam

[plex303]

ALTER TABLE table_name AUTO_INCREMENT = 1