UPDATE t_erp_company t SET t.province_id=(SELECT e.region FROM erp_info e WHERE t.organization_code = e.organizational_code)
WHERE t.province_id IS NULL OR LENGTH(t.province_id)!=6;
为空插入数据,不为空保留代码
最新推荐文章于 2023-04-21 10:50:24 发布
UPDATE t_erp_company t SET t.province_id=(SELECT e.region FROM erp_info e WHERE t.organization_code = e.organizational_code)
WHERE t.province_id IS NULL OR LENGTH(t.province_id)!=6;