phpmyadmin/mysql autoincrement

andehlu

this modern love
Hey all,

I have my primary key as auto increment everything is working fine. But I am in developement right now and when I delete all records then make another insert the id is still as if the old records were there.. is there anyway to reset the increment value back to 0 thru myadmin. I see where it says increment value, 'Next Index' but i cant see how to reset it...thanks.
 

andehlu

this modern love
hmmm i tried this, myadmin says that it executes successfully but my Next Autoindex has not changed and new records do not start at 0.... thanks for the link Ill look into it more.
 

ksv

web developer
It should reset with
Code:
TRUNCATE TABLE `tbl_name`;
which empties table data and indexes
 
Top