Simple example of generating new id’s in ascending order in MySQL.
SET @count = 0; UPDATE `users` SET `users`.`id` = @count:= @count + 1;
Knowledge should be free and accessible
Simple example of generating new id’s in ascending order in MySQL.
SET @count = 0; UPDATE `users` SET `users`.`id` = @count:= @count + 1;