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; |