[SOLVED] reset auto_increment

[dadamssg]

i have a table that still want to keep but i've used it for practice so much that the auto_increment value is ridiculously high. is there anyway to reset the auto_increment? all of the contents are useless to me so i can delete all the rows but i still want to keep the columns

[Mchl]

TRUNCATE TABLE resets auto_increment counter

 

You can also just use ALTER TABLE

[mandred]

You can do what Mchl said by going into phpMyAdmin, selecting the table, and clicking the "EMPTY" button.

[dadamssg]

thanks!