bitscn.com
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;
作者“ylqmf的专栏”
bitscn.com