Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SET @num := 0;
- UPDATE your_table SET id = @num := (@num+1);
- ALTER TABLE `your_table` AUTO_INCREMENT = 1;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement