如何使用MySQL来按顺序排列数据库重新排序ID号？
update players as p
set p.id = (
SELECT count(*) from (select id from players) as sub
where p.id > sub.id
)
或使用>=(如果要从1开始)评论
update players as p
set p.id = (
SELECT count(*) from (select id from players) as sub
where p.id > sub.id
)
或使用>=(如果要从1开始)