mysql怎么批量更新某个字段,从某个值开始并以加一方式的递增

set @var = 100;
update table_name set num = (@var := @var + 1) where id > 100;//更新每行数据时会先运算@var := $var + 1,然后更新字段.

此方式,还可以在查询数据用来标记排名,或者第几行, 如下

set @var = 0;
select (@var := @var + 1) as num, name where id > 100;

源自我的blog: https://blog.nice100.net/mysql/172.html