dadamssg Posted April 15, 2009 Share Posted April 15, 2009 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 Link to comment https://forums.phpfreaks.com/topic/154197-solved-reset-auto_increment/ Share on other sites More sharing options...
Mchl Posted April 15, 2009 Share Posted April 15, 2009 TRUNCATE TABLE resets auto_increment counter You can also just use ALTER TABLE Link to comment https://forums.phpfreaks.com/topic/154197-solved-reset-auto_increment/#findComment-810595 Share on other sites More sharing options...
mandred Posted April 15, 2009 Share Posted April 15, 2009 You can do what Mchl said by going into phpMyAdmin, selecting the table, and clicking the "EMPTY" button. Link to comment https://forums.phpfreaks.com/topic/154197-solved-reset-auto_increment/#findComment-810648 Share on other sites More sharing options...
dadamssg Posted April 15, 2009 Author Share Posted April 15, 2009 thanks! Link to comment https://forums.phpfreaks.com/topic/154197-solved-reset-auto_increment/#findComment-810760 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.