INSERT INTO uf_kcgl (wlbm, wlmc, kf, kz) SELECT wlbm, wlmc, kf, kz FROM table_name WHERE kcid IS NULL;

INSERT INTO uf_kcgl_dt1 (mainid, wlbm, wlmc, kf, kz) SELECT kcid, wlbm, wlmc, kf, kz FROM table_name WHERE kcid IS NOT NULL;

执行合并语句:

INSERT INTO uf_kcgl (wlbm, wlmc, kf, kz) SELECT wlbm, wlmc, kf, kz FROM table_name WHERE kcid IS NULL; UNION ALL SELECT wlbm, wlmc, kf, kz FROM table_name WHERE kcid IS NOT NULL;

INSERT INTO uf_kcgl_dt1 (mainid, wlbm, wlmc, kf, kz) SELECT kcid, wlbm, wlmc, kf, kz FROM table_name WHERE kcid IS NOT NULL

写一个sql语句满足条件kcid为空时把wlbmwlmckfkz插入到表uf_kcgl和表uf_kcgl_dt1中;kcid字段有值时只插入表uf_kcgl_dt1条件为mainid = kcid。把他们合并成一个语句执行

原文地址: https://www.cveoy.top/t/topic/fcpl 著作权归作者所有。请勿转载和采集!

免费AI点我,无需注册和登录