When I create a table with the column "Id int null auto_increment" and enter values in the table, after deleting the values and reinserting them, the Id does not start from 1, and sometimes with a random order. And besides 8 row (s) affected Records appears, also appears 8 Duplicates, even the values have already been deleted from the table. Could someone help me restore my Id from 1 after restarting the table?
