本文最后更新于 877 天前，其中的信息可能已经有所发展或是发生改变。
Statement violates GTID consistency
报错信息：Statement violates GTID consistency: Updates to non-transactional tables,can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
解决
使用mysql版本为5.7，在配置文件my.cnf 中将
gtid_mode = ON
enforce_gtid_consistency = 1
修改成以下参数后，然后重启mysql，问题得到解决
gtid_mode = OFF
enforce_gtid_consistency = 0
gtid_mode 参数解析:https://blog.csdn.net/weihaodong0557/article/details/109598729