写一个sql语句当uf_shdb_dt1表中kcid字段为空时把wlbmwlmckfkz插入到表uf_kcgl和表uf_kcgl_dt1中;当uf_shdb_dt1表中kcid字段有值时只插入表uf_kcgl_dt1条件为mainid = kcid
INSERT INTO uf_kcgl (wlbm, wlmc, kf, kz) SELECT wlbm, wlmc, kf, kz FROM uf_shdb_dt1 WHERE kcid IS NULL;
INSERT INTO uf_kcgl_dt1 (mainid, wlbm, wlmc, kf, kz) SELECT kcid, wlbm, wlmc, kf, kz FROM uf_shdb_dt1 WHERE kcid IS NOT NULL;
原文地址: https://www.cveoy.top/t/topic/fcoZ 著作权归作者所有。请勿转载和采集!