根据原表创建临时表
CREATE TEMP TABLE temp_table as (select * from table limit 0);
本次使用完临时表后自动删除
CREATE TEMP TABLE temp_table ON COMMIT DROP as (select * from table limit 0);
ON COMMIT DROP 表示本次事务提交后就自动删掉了
CREATE TEMP TABLE temp_table as (select * from table limit 0);
CREATE TEMP TABLE temp_table ON COMMIT DROP as (select * from table limit 0);
ON COMMIT DROP 表示本次事务提交后就自动删掉了