当前位置：Gxlcms >
数据库问题 >
mysql error：@@GLOBAL.ENFORCE_GTID_CONSISTENCY = 1，updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions
mysql error：@@GLOBAL.ENFORCE_GTID_CONSISTENCY = 1，updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions
时间：2021-07-01 10:21:17
帮助过：4人阅读
, 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.
解决：
查看开发脚本，一个脚本的单个事务中存在以下内容：
insert插入到innodb表，update 更新的是mysaim表 。
联系开发sql拆分两个脚本 分开提交，问题解决。
mysql error：@@GLOBAL.ENFORCE_GTID_CONSISTENCY = 1，updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions
标签：开发 tran erro ORC either state date insert 联系
