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;
?
日期:2014-05-16 浏览次数:20705 次
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;
?