Advertisement
killerbng

Reset id auto increment

May 25th, 2015
328
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.82 KB | None | 0 0
  1. ALTER TABLE `users` DROP `id`;
  2. ALTER TABLE `users` AUTO_INCREMENT = 1;
  3. ALTER TABLE `users` ADD `id` int UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST;
  4.  
  5.  
  6. //Example
  7. ALTER TABLE `br_words` DROP `id`;
  8. ALTER TABLE `br_words` AUTO_INCREMENT = 1;
  9. ALTER TABLE `br_words` ADD `id` int UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST;
  10. ALTER TABLE `de_words` DROP `id`;
  11. ALTER TABLE `de_words` AUTO_INCREMENT = 1;
  12. ALTER TABLE `de_words` ADD `id` int UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST;
  13. ALTER TABLE `fi_words` DROP `id`;
  14. ALTER TABLE `fi_words` AUTO_INCREMENT = 1;
  15. ALTER TABLE `fi_words` ADD `id` int UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST;
  16. ALTER TABLE `ru_words` DROP `id`;
  17. ALTER TABLE `ru_words` AUTO_INCREMENT = 1;
  18. ALTER TABLE `ru_words` ADD `id` int UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement