MySql INSERT WHERE然后选择子查询

Question

我正在尝试将值插入到一个表中，其中行的ID只能通过在另一个表上执行SELECT where来找到。下面是我的问题：

INSERT INTO wp_postmeta (meta_key, meta_value) 
VALUES ('editor_review','5') 
WHERE post_id=(SELECT ID from wp_posts 
               WHERE post_title 
              LIKE "%The Honest Kitchen ZEAL Grain Free Gluten Free All Life Stages Dog Food%");

对此有什么想法吗？

谢谢

Answer 1

INSERT INTO wp_postmeta
    (post_id, meta_key, meta_value)
    SELECT id, 'editor_review', '5'
        FROM wp_posts
        WHERE post_title LIKE '%The Honest Kitchen ZEAL Grain Free Gluten Free All Life Stages Dog Food%'

Answer 2

为此，您可以使用INSERT INTO...SELECT语句。

INSERT INTO wp_postmeta (meta_key, meta_value) 
SELECT colA, colB
FROM wp_posts 
WHERE post_title 
LIKE "%The Honest Kitchen ZEAL Grain Free Gluten Free All Life Stages Dog Food%"

请注意，列数必须相互匹配(以及它们的数据类型)