MySQL给一个字段递增赋值

想要飞的小乌龟转载数据库 2022/08/04 10:56:38 241 阅读约 5 分钟

摘要: set @r:=0; update szg_train_gps_bind_pigeon set rank_index=(@r:=@r+1) where train_id = '1457175338646966272'

set @r:=0;
update szg_train_gps_bind_pigeon set rank_index=(@r:=@r+1) where train_id = '1457175338646966272'

241 阅读 ← 返回技术栈