写一个sql语句满足条件kcid为空时把wlbmwlmckfkz插入到表uf_kcgl和表uf_kcgl_dt1中;kcid字段有值时只插入表uf_kcgl_dt1条件为mainid = kcid。把他们合并成一个语句执行
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
原文地址: https://www.cveoy.top/t/topic/fcpl 著作权归作者所有。请勿转载和采集!