I'm looking for a simple solution to get the ID column in my table to start from 0 and auto increment without deleting the rows or having to manually change the ID in the database.
I have around 120 rows in the table, the first record starts with the ID: 2, I want this as '0' and all the other rows to update in ascending order.
I understand the AUTO_INCREMENT would solve this solution if I deleted all my rows.
You can see by the way the numbers are ordered in the below table.
I hope I've explained myself properly and any help would be greatly appreciated.