mysql5.7用命令create table xxxxx select * from xx 报错

mysql5.7用命令create table xxxxx select * from xx 报错
解决办法：
分两步进行
create table xxxx like xx;
insert into xxxx select * from xx;