(1)定义字段CREATE TEMPORARY TABLE tmp_table 
                (name VARCHAR(10) NOT NULL,        
                value INTEGER NOT NULL)     
(2)直接将查询结果导入临时表CREATE TEMPORARY TABLE tmp_table SELECT * FROM table_name

select * from tmp_table

drop table tmp_table