数据库 根据A表 更新B表

--------------------oracle 根据A表 批量更新B表----------------------
update t_b_loans a set a.create_by_org=
(select b.org_code from t_s_depart b where a.setup_tsdepart_id = b.id) where exists
(select * from t_s_depart c where c.id=a.setup_tsdepart_id)
commit;


--------------------mysql 根据A表 批量更新B表----------------------
UPDATE table_a,table_b SET table_a.age=table_b.age WHERE table_a.id=table_b.id;