从t1连接更新t1查询(选择)

Question

我有过

You have an error in your SQL syntax;
check the manual that corresponds to your MySQL server version
for the right syntax to use near 'FROM cards t1

    t1
SET
    t1.driver = t2.mv,
    t1.number = t2.pt
FROM 
    cards t1
    LEFT JOIN 
        (SELECT meta_value mv, post_title pt
        FROM wpwx_posts 
        LEFT OUTER JOIN wpwx_postmeta AS PM
        ON post_id = ID
        AND meta_key = 'cardholder'
        WHERE post_type='bilet') t2
    ON t1.number = t2.pt  

()中的代码是正确的，可以使用

FROM cards AS t1
    LEFT JOIN (SELECT PM.meta_value AS mv, P.post_title AS pt
        FROM wpwx_posts AS P 
        LEFT OUTER JOIN wpwx_postmeta AS PM
        ON PM.post_id = ID
        AND PM.meta_key = 'cardholder'
        WHERE P.post_type='bilet') AS t2
    ON t1.number = t2.pt

Answer 1

似乎您正在尝试更新表，并且在SET之后使用SET将是无效的语法。发布整个查询将是有帮助的。