作者:魅由心生先_941 | 来源:互联网 | 2018-06-10 15:06
mysql产生行号mysql产生行号:set@n0;updatetbl_material_stonea,(selectstone_id,@n:@n+1rfromtbl_material_stoneorderbystone_id)bsetnorwherea.stone_idb.stone_id;?
mysql产生行号 mysql产生行号: set @n = 0;update tbl_material_stone a, (select stone_id,@n:=@n+1 r from tbl_material_stone order by stone_id) b set no = r where a.stone_id =b.stone_id; ?
mysql产生行号
mysql产生行号:
set @n = 0;
update tbl_material_stone a, (select stone_id,@n:=@n+1 r from tbl_material_stone order by stone_id) b set no = r where a.stone_id =b.stone_id;
?