What's wrong with mysql reset auto increment in codeigniter? |
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 ![]() |
Messages In This Thread |
What's wrong with mysql reset auto increment in codeigniter? - by Ukasyah - 05-17-2017, 05:39 PM
RE: What's wrong with mysql reset auto increment in codeigniter? - by skunkbad - 05-17-2017, 07:26 PM
RE: What's wrong with mysql reset auto increment in codeigniter? - by Ukasyah - 05-17-2017, 09:44 PM
RE: What's wrong with mysql reset auto increment in codeigniter? - by Rufnex - 05-18-2017, 12:33 AM
RE: What's wrong with mysql reset auto increment in codeigniter? - by InsiteFX - 05-18-2017, 01:31 AM
RE: What's wrong with mysql reset auto increment in codeigniter? - by skunkbad - 05-18-2017, 07:46 AM
RE: What's wrong with mysql reset auto increment in codeigniter? - by Martin7483 - 05-19-2017, 03:54 AM
|