1 2 3 4 5 6
drop table if exists t1; create table t1 (id int) engine=myisam; insert into t1 values (1); create temporary table t2 select * from t1; drop temporary table t2; drop table t1;