历史表更新数据

http://www.jb51.net/article/41852.htm

update temp_crd_wy_group temp ,crd_wy_group cwg set cwg.`dept_code` = temp.dept_code ,cwg.company_code = temp.company_code
where cwg.`id` = temp.id