set @r:=100;
update `test-uid` set uid=(@r:=@r+1);
插入(找一个多个表):
set @r:=0;
insert into t select @r:=@r+1 from t1 limit 0, 2000
set @r:=100;
update `test-uid` set uid=(@r:=@r+1);
插入(找一个多个表):
set @r:=0;
insert into t select @r:=@r+1 from t1 limit 0, 2000