为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:8
【操作系统】:winds
【CPU】:x64
【问题描述】*:UPDATE zszx.EM_SUPPORT_PROJECT_PLAN_DETAIL A,
(
SELECT A.ID as entpriseId ,1 AS count FROM zszx.EM_ENTPRISE_MASTER A
WHERE IFNULL(A.REG_ADDRESS,'') <> ''
AND IFNULL(A.REG_ADDRESS_OLD,'') <> ''
AND A.REG_ADDRESS <> A.REG_ADDRESS_OLD
GROUP BY A.ID
) B
SET A.EARLY_WARNING_NUMBERT = IFNULL(A.EARLY_WARNING_NUMBERT,0) + B.count
WHERE A.PLAN_ID = 1 AND A.ENTPRISE_ID = B.entpriseId
试一下下面这个写法是否能正常执行
UPDATE zszx.EM_SUPPORT_PROJECT_PLAN_DETAIL A SET A.EARLY_WARNING_NUMBERT = IFNULL(A.EARLY_WARNING_NUMBERT,0) + B.count FROM (SELECT A.ID as entpriseId ,1 AS count FROM zszx.EM_ENTPRISE_MASTER A WHERE IFNULL(A.REG_ADDRESS,'') <> '' AND IFNULL(A.REG_ADDRESS_OLD,'') <> '' AND A.REG_ADDRESS <> A.REG_ADDRESS_OLD GROUP BY A.ID ) B WHERE A.PLAN_ID = 1 AND A.ENTPRISE_ID = B.entpriseId