Reset MySQL Auto Increment number


/ Published in: MySQL
Save to your folder(s)

for auto increment ids, when you delete records this will reset the number for the next auto id.


Copy this code and paste it in your HTML
  1. ALTER TABLE tablename AUTO_INCREMENT = 1

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.