MySQL 使用查询结果创建表

MYSQL不支持:
Select * Into new_table_name from old_table_name;

替代方法:

1

Create table new_table_name (Select * from old_table_name);

select * into new_table_name from old_table_name;

2

SELECT *  INTO OUTFILE 'a.txt' FROM table_name;
 LOAD DATA INFILE '/database/mysql/a.txt' INTO TABLE new_table_name;