update players as p
set p.id = (
SELECT count(*) from (select id from players) as sub
where p.id > sub.id
)
或使用>=(如果要从1开始)如何使用MySQL来按顺序排列数据库重新排序ID号？
- 发表于2022/5/12 14:35
- 1781浏览
- 0评论
- 1分钟阅读
评 论
update players as p
set p.id = (
SELECT count(*) from (select id from players) as sub
where p.id > sub.id
)
或使用>=(如果要从1开始)