"Reboot" ID row

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
powerPT
Forum Newbie
Posts: 14
Joined: Tue Apr 04, 2006 2:25 pm
Location: Portugal

"Reboot" ID row

Post 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!
User avatar
Chris Corbyn
Breakbeat Nuttzer
Posts: 13098
Joined: Wed Mar 24, 2004 7:57 am
Location: Melbourne, Australia

Post by Chris Corbyn »

Hi, do you mean you want to reset the counter back to the start value? :)
powerPT
Forum Newbie
Posts: 14
Joined: Tue Apr 04, 2006 2:25 pm
Location: Portugal

Post by powerPT »

Yeah! :D
User avatar
JayBird
Admin
Posts: 4524
Joined: Wed Aug 13, 2003 7:02 am
Location: York, UK
Contact:

Post by JayBird »

Code: Select all

ALTER TABLE table_name AUTO_INCREMENT = 0;
Post Reply