mysql - 根据连接结果插入mysql表

Question

我的 MySQL JOIN 查询按预期工作:

SELECT subjectmie_subclasss.id AS subcl, subjectmie_classs.id AS cla, 
    subjectmie_subject.id AS subj,
    CONCAT_WS(', ' ,subjectmie_subclasss.subclasss, subjectmie_classs.classs, subjectmie_subject.subject)
    AS subjectcl        
FROM subjectmie_subclasss
INNER JOIN subjectmie_subject
    ON subjectmie_subject.id = subjectmie_subclasss.subject_id
LEFT JOIN subjectmie_classs
    ON subjectmie_classs.id = subjectmie_subclasss.classs_id;

但是我的目的是将这些值放入表格中。

目前，我的想法是将结果放入新表subject_classs中:

INSERT INTO subject_classs
    (subject_id, classs_id, subclasss_id, subject_classs)
    SELECT subjectmie_subject.id AS subj, subjectmie_classs.id AS cla, 
        subjectmie_subclasss.id AS subcl,  
        CONCAT_WS(', ' ,subjectmie_subclasss.subclasss, subjectmie_classs.classs, subjectmie_subject.subject)
        AS subjectcl        
    FROM subjectmie_subclasss
    INNER JOIN subjectmie_subject
        ON subjectmie_subject.id = subjectmie_subclasss.subject_id
    LEFT JOIN subjectmie_classs
        ON subjectmie_classs.id = subjectmie_subclasss.classs_id;
VALUES(subj, cla, subcl, subjectcl)

这个QUERY显然是不正确的，它在我执行查询之前就在MySQL workbench中显示了错误，因此查询逻辑是错误的。有人可以建议我如何在我的 JOIN 查询中使用 INSERT 吗？

Answer 1

只需删除 values 子句就可以了:

INSERT INTO subject_classs
    (subject_id, classs_id, subclasss_id, subject_classs)
    SELECT subjectmie_subject.id AS subj, subjectmie_classs.id AS cla, 
        subjectmie_subclasss.id AS subcl,  
        CONCAT_WS(', ' ,subjectmie_subclasss.subclasss, subjectmie_classs.classs, subjectmie_subject.subject)
        AS subjectcl        
    FROM subjectmie_subclasss
    INNER JOIN subjectmie_subject
        ON subjectmie_subject.id = subjectmie_subclasss.subject_id
    LEFT JOIN subjectmie_classs
        ON subjectmie_classs.id = subjectmie_subclasss.classs_id;