Advertisement
AdhityaRimba

Reorder ID

Feb 19th, 2021
785
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.12 KB | None | 0 0
  1. SET @count = 0;
  2. UPDATE `notifikasi` SET `notifikasi`.`id` = @count:= @count + 1;
  3. ALTER TABLE `notifikasi` AUTO_INCREMENT = 1;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement