JZTXT

MySQL将一张表的字段更新进另一张表

发布时间 2023-06-16 18:45:20作者: JaxYoun
-- 1.统计语句
select COUNT(*) from ZD_JGZC_MAP_BIRTH zjmb inner join xydm x on zjmb.NEWJGBM = x.信用代码;

-- 2.更新语句
update ZD_JGZC_MAP_BIRTH as a, xydm as b set a.NEWJGBM = b.信用代码 WHERE b.信用代码 IS NOT NULL AND b.信用代码 != '' AND a.JGBM = b.JGBM;
update ZD_JGZC_MAP_BIRTH as a, xydm as b set a.NEWJGBM = b.信用代码 WHERE b.信用代码 IS NOT NULL AND b.信用代码 != '' AND a.JGMC = b.JGMC;