mysql中不支持对查询修改,即对查询结果进行修改
解决方法;将查询结果进行临时表转化即可:
错误sql:
UPDATE go_order_pj
SET project_code = ‘02’
WHERE
go_order_pj_id IN (
SELECT
go_order_pj_id
FROM
go_order_pj
WHERE
go_order_id IN (
SELECT
go_order_id
FROM
go_order
WHERE
org_id = ‘6482277243980976128’
)
)
解决后sql:
UPDATE go_order_pj
SET project_code = ‘02’
WHERE
go_order_pj_id IN (
SELECT
go_order_pj_id
FROM
(
SELECT
go_order_pj_id
FROM
go_order_pj
WHERE
go_order_id IN (
SELECT
go_order_id
FROM
go_order
WHERE
org_id = ‘6482277243980976128’
)
) AS temp
)