//如果rownid为主键
UPDATE ss set rownid=rownid+100001;
UPDATE ss set rownid=rownid-100000;
UPDATE ss,(SELECT MAX(rownid) a from ss a) a set ss.rownid=1 where ss.rownid=a.a;
SELECT * from ss order by rownid;//不为主键
UPDATE ss set rownid=rownid+1;
UPDATE ss,(SELECT MAX(rownid) a from ss a) a set ss.rownid=1 where ss.rownid=a.a;
SELECT * from ss order by rownid;
UPDATE ss set rownid=rownid+100001;
UPDATE ss set rownid=rownid-100000;
UPDATE ss,(SELECT MAX(rownid) a from ss a) a set ss.rownid=1 where ss.rownid=a.a;
SELECT * from ss order by rownid;//不为主键
UPDATE ss set rownid=rownid+1;
UPDATE ss,(SELECT MAX(rownid) a from ss a) a set ss.rownid=1 where ss.rownid=a.a;
SELECT * from ss order by rownid;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货