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 Related Snips Reset MySQL Root Password Set MySQL Root Password Export MySQL Dump Change Table Storage Engine MySQL Stored Function: urlencode/urldecode Hide Sidebar