mysqlprimary-key

Resetting the primary key to 1 after deleting all the data

So i have MySql and i have a table user with a user_id column and it is the primary key and auto incremented. Now when i delete all my data from the table and add the new one, the user_id does not start from 1 but from the number it had before deletion. What if i want to reset it without dropping the whole table and creating it again.

Solution 
  • ALTER TABLE some_table AUTO_INCREMENT=1

    So some_table would be the table you want to alter.

    You could also use:

    TRUNCATE TABLE some_table

    This will reset the Auto Increment on the table as well as deleting all records from that table.