MySQL错误ERROR 1786 (HY000)解决
务上需要支持create table XXX as select * from XXX; 这种创建表的语法,但是MySQL5.7.x版本里面gtid是开启的,会报错ERROR 1786 (HY000):Statement violates GTID consistency: CREATE TABLE ... SELECT.官方说明:https://dev.mysql.com/doc/refman/5.7/en/replication-gtids-restrictions.htmlCREATE T.
原创
2020-08-23 19:20:49 ·
1805 阅读 ·
0 评论