auto increment の連番を振り直したい。
phpmyadmin の SQL にて
SET @i := 0 ;
UPDATE users SET id = (@i := @i +1) ;
ALTER TABLE users AUTO_INCREMENT = 10000
これで users テーブルの 連番が 10000 から振り分けられるようになる。
More than 5 years have passed since last update.
Register as a new user and use Qiita more conveniently
- You get articles that match your needs
- You can efficiently read back useful information
- You can use dark theme
List of users who liked
12