mysql - Reorder / reset auto increment primary key - Stack Overflow

Sat Jan 15 2022 20:59:04 GMT+0000 (Coordinated Universal Time)

Saved by @MojoM

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;