Forum Moderators: open

Message Too Old, No Replies

MySQL Table (ID auto increment)

         

tonynoriega

4:44 pm on Jan 29, 2007 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



is there anyway to re-start the auto increment?

i had 1-30 test records in there and delted them to make room for actual records, and it continued at 31...

i would like to start fresh with record 1 and so on...

or am i going to have to create a new table?

justageek

6:05 pm on Jan 29, 2007 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



ALTER TABLE tbl AUTO_INCREMENT = 1;

JAG

wheelie34

6:52 pm on Jan 29, 2007 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



or just delete the table and re add it