MYSQL不支持:
Select * Into new_table_name from old_table_name;
LOAD DATA INFILE '/database/mysql/a.txt' INTO TABLE new_table_name;
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
LOAD DATA INFILE '/database/mysql/a.txt' INTO TABLE new_table_name;