1、复制一个imooc_goddess 表 的备份表,imooc_goddess_bak:
create table imooc_goddess_bak as select * from imooc_goddess;
报错了;1786 - Statement violates GTID consistency: CREATE TABLE ... SELECT.
2、解决办法如下
create table imooc_goddess_bak like imooc_goddess;
insert into imooc_goddess_bak select * from imooc_goddess;