MySQL。从结果查询填充表，其中列数不同

Question

我有一个包含 12 列的空表(第一个是 ID AUTO_INCREMENT)。

我必须直接从给我 8 列的查询中填充此表。这是查询

INSERT INTO table_name
    SELECT t.one,
           ag.two AS two_name,
           a.three,
           a.four,
           t.five,
           s.six as six_name,
           s.seven as seven_name,
           s.eight as eight_name,
           '-',
           '-',
           '-'
    FROM table_t AS t
        JOIN table_st AS st ON t.trip_id = st.trip_id 
        JOIN table_s AS s ON s.s_id = st.a_id 
        JOIN table_a AS a ON a.a_id = t.a_id 
        JOIN agency_group AS ag ON ag.id = t.a_id
    WHERE 
        st.somefield = 1
    ORDER BY t.somefield ASC 
                     ;

如果我单独运行这个子查询(没有 INSERT INTO table_name)它工作正常。

当我完全像上面写的那样运行它以便将这些结果直接输入到表中时，我得到了这个错误:

1136 - Column count doesn't match value count at row 1

附言。所有列类型和名称都匹配。

谁能指出问题出在哪里？谢谢

Answer 1

插入时总是列出列:

INSERT INTO table_name (col1, col2, . . ., coln)
    SELECT col1, col2, . . ., coln
    FROM . . .

错误信息很清楚。该表的列数多于或少于 SELECT。