UPDATE `TABLE` SET `FIELD` = (SELECT a.FIELD FROM (SELECT FIELD FROM TABLE b WHERE 条件) a) WHERE 条件;
You can‘t specify target table ‘a‘ for update in FROM clause
最新推荐文章于 2024-07-20 16:33:27 发布
UPDATE `TABLE` SET `FIELD` = (SELECT a.FIELD FROM (SELECT FIELD FROM TABLE b WHERE 条件) a) WHERE 条件;