update跨庫跨表例子

2009-11-16 10:47 641 0

摘要: 季凡 update chr_point set point=point+300 where id_idx in(select character_idx from mhgame.dbo.tb_cha...

关键词： point where character idx select update user mhgame chr set

季凡 update chr_point set point=point+300 where id_idx in(select character_idx from mhgame.dbo.tb_character where zhuansheng= '6' and CHARACTER_GRADE= '99')update chr_point set point=300 where id_idx in(select user_idx from mhgame.dbo.tb_character where zhuansheng= '6' and CHARACTER_GRADE= '99') update chr_point set point=1000 where id_idx in(select user_idx from mhgame.dbo.tb_character where user_idx=371) update chr_point set point=700 where id_idx in(select user_idx from mhgame.dbo.tb_character where user_idx=492) update chr_point set point=500 where id_idx in(select user_idx from mhgame.dbo.tb_character where user_idx=473) update chr_point set point=100 where id_idx in(select user_idx from mhgame.dbo.tb_character where zhuansheng <= 6 and CHARACTER_GRADE< '99') update chr_point set point=point+100 where id_idx in(select id_idx from chr_log_info where id_loginid in (select user_id from LoginTable))

声明：文章版权归原作者所有部分文章转自互联网如有侵权请联系 [邮箱地址] 删除