高级玩家

- 贡献度
- 0
- 金元
- 3976
- 积分
- 398
- 精华
- 0
- 注册时间
- 2017-3-19
|
create table Item_drop_b as
select * from Item_drop;
update Item_drop set RndDrop_NumRange=(
select replace(Item_drop_b.RndDrop_NumRange,',0.','0,0.') from Item_drop_b where Item_drop.Id=Item_drop_b.Id
)
update Item_drop_b set RndDrop_NumRange=(
select RndDrop_NumRange from Item_drop where Item_drop.Id=Item_drop_b.Id
);
update Item_drop set RndDrop_NumRange=(
select replace(Item_drop_b.RndDrop_NumRange,',1','0,1') from Item_drop_b where Item_drop.Id=Item_drop_b.Id
);
drop table Item_drop_b;
|
|