Reset MySQL Auto Increment number


/ Published in: MySQL

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.