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. Quote 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. Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.