Home › Code Snips › Reset Next Row’s Auto Increment Value In MySQL Reset Next Row’s Auto Increment Value In MySQL by Kyle on December 04, 2009 · Posted in MySQL ALTER TABLE `tbl_name` AUTO_INCREMENT = 1; Save. Share. Submit. Digg · Twitter · StumbleUpon · Delicious · Facebook · Google · Reddit · Technorati Rate Snippet 1 2 3 4 5 Related Snips Export MySQL Dump Reset MySQL Root Password Set MySQL Root Password MySQL Stored Function: urlencode/urldecode Change Table Storage Engine Hide Sidebar