mysql从复杂选择直接插入

Question

我有这个 MySQL SELECT:

SELECT t.*,
 sum(HOUR(TIMEDIFF(STR_TO_DATE(Arbeitsbeginn, '%d.%m.%Y %H:%i:%s'),
 STR_TO_DATE(Arbeitsende, '%d.%m.%Y %H:%i:%s')))) AS ARBEITSZEIT,
sum(HOUR(TIMEDIFF(STR_TO_DATE(Projektbeginn, '%d.%m.%Y %H:%i:%s'),
STR_TO_DATE(Projektende, '%d.%m.%Y %H:%i:%s')))) AS Projektzeit

FROM (SELECT DriverName,
         Baustelle,
         Arbeitsbeginn,
         Arbeitsende,
        Projektbeginn,
        Projektende
  FROM (SELECT DRIVERNAME,
               GROUP_CONCAT(IF(ACTIONTEXT = 'PB', AREA, NULL)) AS 'Baustelle',
               GROUP_CONCAT(IF(ACTIONTEXT = 'Arbeitsbeginn', DATETIME, NULL)) AS 'Arbeitsbeginn',
               GROUP_CONCAT(IF(ACTIONTEXT = 'Arbeitsende', DATETIME, NULL)) AS 'Arbeitsende',
               GROUP_CONCAT(IF(ACTIONTEXT = 'PB', DATETIME, NULL)) AS 'Projektbeginn',
               GROUP_CONCAT(IF(ACTIONTEXT = 'PE', DATETIME, NULL)) AS 'Projektende'
        FROM geoImportRoot
        GROUP BY DRIVERNAME
       ) A CROSS JOIN
       (SELECT 1 AS n UNION ALL SELECT 2) n
) t
GROUP BY DriverName;

是否可以将其直接插入到新表中？

Answer 1

要从 select 语句创建新表，您可以使用:

CREATE TABLE .... SELECT

它基本上是一个附加了 SELECT 语句的 CREATE TABLE 语句。

<小时/>

如果您希望将 SELECT 结果插入现有表中，请改用 INSERT ... SELECT声明。