bulrush Posted August 17, 2010 Share Posted August 17, 2010 Mysql 4.1.11 How do I reset the auto inc ID on all my tables? They are used as keys. When I finish my testing I want to roll this out to production and reset the IDs. Link to comment https://forums.phpfreaks.com/topic/210979-resetting-autoinc-id-in-mysql/ Share on other sites More sharing options...
mikosiko Posted August 17, 2010 Share Posted August 17, 2010 drop/create table or truncate table will reset the autoinc. Link to comment https://forums.phpfreaks.com/topic/210979-resetting-autoinc-id-in-mysql/#findComment-1100443 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.