MySQL创建临时表

Question

无法理解为什么这个创建临时表不起作用..任何人都可以建议..？

create temporary table if not exists table2 AS (select unix_timestamp(concat(delivery_date, ' ', str_to_date(delivery_time,'%h:%i%p'))) as timestamp, id from fruit.order_delivery_orders where calendar_id is not null);

出现错误“查询中断”。

这个查询工作正常 -

select unix_timestamp(concat(delivery_date, ' ', str_to_date(delivery_time,'%h:%i%p'))) as timestamp, id from fruit.order_delivery_orders where calendar_id is not null

Answer 1

请使用以下语法。希望这对您有帮助。

 CREATE TABLE [ IF NOT EXISTS ] table_name AS SELECT column_names FROM table_name_2 WHERE condition;