Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.
Moderator: General Moderators
-
powerPT
- Forum Newbie
- Posts: 14
- Joined: Tue Apr 04, 2006 2:25 pm
- Location: Portugal
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!
-
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!

-
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;