无法在phpMyAdmin中将查询结果插入SQL查询

Question

我正在运行以下查询：

SELECT *
INTO consolidated
FROM    (SELECT qtyAvailable
            FROM  Inventory
            UNION ALL
            SELECT revenue,
                   location,
                   qtySold
            FROM   sales
            UNION ALL
            SELECT inactive,
                   new,
                   itemNum,
                   category,
                   subCategory,
                   color,
            FROM Masterlist) n

得到这些错误

    Error
SQL query: Documentation


SELECT *
INTO consolidated
FROM    (SELECT qtyAvailable
            FROM  Inventory
            UNION ALL
            SELECT revenue,
                   location,
                   qtySold
            FROM   sales
            UNION ALL
            SELECT inactive,
                   new,
                   itemNum,
                   category,
                   subCategory,
                   color,
            FROM Masterlist) n
 LIMIT 0, 25 
MySQL said: Documentation

#1327 - Undeclared variable: consolidated

当我删除新表或“变量”时，此错误

Error
SQL query: Documentation


SELECT *
FROM    (SELECT qtyAvailable
            FROM  Inventory
            UNION ALL
            SELECT revenue,
                   location,
                   qtySold
            FROM   sales
            UNION ALL
            SELECT inactive,
                   new,
                   itemNum,
                   category,
                   subCategory,
                   color,
            FROM Masterlist) n
 LIMIT 0, 25 
MySQL said: Documentation

#1064 - 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 Masterlist) n
LIMIT 0, 25' at line 16 

当我去掉n时，类似的错误

Error
SQL query: Documentation


SELECT *
FROM    (SELECT qtyAvailable
            FROM  Inventory
            UNION ALL
            SELECT revenue,
                   location,
                   qtySold
            FROM   sales
            UNION ALL
            SELECT inactive,
                   new,
                   itemNum,
                   category,
                   subCategory,
                   color,
            FROM Masterlist)
 LIMIT 0, 25 
MySQL said: Documentation

#1064 - 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 Masterlist)
LIMIT 0, 25' at line 16 

我对myPHP没有很深的经验，但基本上我是在一个数据库中的三个表上运行一个查询，我想将结果插入到一个新表中，我称之为合并表。我创建了合并表，并将列保留为空。我不知道从哪里开始，提前感谢您的帮助！此外，我还根据这个post提出了一个初始查询

Answer 1

在最后一个from子句之前有一个多余的逗号，这将导致第二个错误。无论如何，select ... into语法在MySQL中不受支持。相反，您应该使用insert ... select语法：

INSERT INTO consolidated 
SELECT *
FROM    (SELECT qtyAvailable
         FROM  Inventory
         UNION ALL
         SELECT revenue,
                location,
                qtySold
         FROM   sales
         UNION ALL
         SELECT inactive,
                new,
                itemNum,
                category,
                subCategory,
                color -- redundant comma removed here
         FROM Masterlist) n