update 跨库跨表例子 -电脑资料

电脑资料时间：2019-01-01 我要投稿

【meiwen.anslib.com - 电脑资料】

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))

相关文章