Page 1 of 1

"Reboot" ID row

Posted: Wed Apr 05, 2006 4:44 am
by powerPT
HI guys!

How a "reboot" id row of "id". The MySQL always be auto-indexing but I wish to put zero this value.

Thanks in advaced!

Posted: Wed Apr 05, 2006 6:19 am
by Chris Corbyn
Hi, do you mean you want to reset the counter back to the start value? :)

Posted: Wed Apr 05, 2006 6:19 am
by powerPT
Yeah! :D

Posted: Wed Apr 05, 2006 6:40 am
by JayBird

Code: Select all

ALTER TABLE table_name AUTO_INCREMENT = 0;