某数据表更新时出现一下异常:
java.sql.SQLException: When @@GLOBAL.ENFORCE_GTID_CONSISTENCY = 1, 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
排查后发现该表的引擎为MyISAM改为InnoDB即可