Welcome Guest, Not a member yet? Register   Sign In
What's wrong with mysql reset auto increment in codeigniter?
#7

1. Select all records and store in array or object. Maybe also save them to a JSON file
2. Truncate the table -> This will reset auto increment
3. (Re)Insert the records from step 1 -> remove existing ID column
4. Your ID's have been rearranged Smile
Reply


Messages In This Thread
RE: What's wrong with mysql reset auto increment in codeigniter? - by Martin7483 - 05-19-2017, 03:54 AM



Theme © iAndrew 2016 - Forum software by © MyBB