killerbng icon

Reset id auto increment

killerbng | PRO | 05/26/15 01:23:00 AM UTC | 0 ⭐ | 505 👁️ | Never ⏰ | []
MySQL |

820 B

|

None

|

0 👍

/

0 👎

Raw Download Clone Embed Print View 
ALTER TABLE `users` DROP `id`;
ALTER TABLE `users` AUTO_INCREMENT = 1;
ALTER TABLE `users` ADD `id` int UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST;
 
 
//Example
ALTER TABLE `br_words` DROP `id`;
ALTER TABLE `br_words` AUTO_INCREMENT = 1;
ALTER TABLE `br_words` ADD `id` int UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST;
ALTER TABLE `de_words` DROP `id`;
ALTER TABLE `de_words` AUTO_INCREMENT = 1;
ALTER TABLE `de_words` ADD `id` int UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST;
ALTER TABLE `fi_words` DROP `id`;
ALTER TABLE `fi_words` AUTO_INCREMENT = 1;
ALTER TABLE `fi_words` ADD `id` int UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST;
ALTER TABLE `ru_words` DROP `id`;
ALTER TABLE `ru_words` AUTO_INCREMENT = 1;
ALTER TABLE `ru_words` ADD `id` int UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST;

Comments