mysql - 'where 子句 [MySQL] 中的未知列 '"'

Question

当我尝试执行此查询时，我收到此错误Erreur SQL (1054) : Unknown column 'pk.post_id' in 'where Clause' 。

UPDATE `wp_posts` as pm  
SET pm.post_content = 
   (select meta_value from `wp_postmeta` as pk where pk.post_id = pm.id and pk.meta_key = "_job_description") 
 WHERE  pm.id = pk.post_id;

我不知道如何解决它。你能帮我解决这个问题吗？

标签： mysqlwordpressxampp

Answer 1

您必须使用多表 UPDATE 语法：

UPDATE `wp_posts` as pm  
JOIN `wp_postmeta` as pk ON pm.id = pk.post_id 
                        AND pk.meta_key = '_job_description'
SET pm.post_content = pk.meta_value;

见https://dev.mysql.com/doc/refman/8.0/en/update.html