gray01 Posted May 8, 2003 Share Posted May 8, 2003 I\'ve got a few tables with auto-increment IDs. I want to delete all data and start again with empty tables. However, the auto-increment value is remembered, so the empty table isnt populated starting with ID = 1, but with the value before the data was deleted - is there a way to reset it? Link to comment https://forums.phpfreaks.com/topic/444-resetting-auto-increment-field/ Share on other sites More sharing options...
pallevillesen Posted May 8, 2003 Share Posted May 8, 2003 ALTER TABLE tbl_name AUTO_INCREMENT = 1; P. Link to comment https://forums.phpfreaks.com/topic/444-resetting-auto-increment-field/#findComment-1506 Share on other sites More sharing options...
gray01 Posted May 8, 2003 Author Share Posted May 8, 2003 thanks biopv - i hope you get paid for technical support Link to comment https://forums.phpfreaks.com/topic/444-resetting-auto-increment-field/#findComment-1511 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.