SET @i:=0;
UPDATE votes_items
SET `number` = (SELECT (@i:=@i+1))
WHERE activity_id = 1701;
最后修改：2023 年 05 月 11 日 10 : 22 AM
© 允许规范转载
赞赏作者
扫一扫支付
mysql序号更新
SET @i:=0;
UPDATE votes_items
SET `number` = (SELECT (@i:=@i+1))
WHERE activity_id = 1701;