python调用存储过程失败返回1787错误

(1787, 'When @@GLOBAL.ENFORCE_GTID_CONSISTENCY = 1, the statements CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can be executed in a non-transactional context only, and require that AUTOCOMMIT = 1.')

  python调用存储过程失败,解决方案:

在存储过程中添加:set @@autocommit=1;    即可解决

posted @ 2019-05-30 09:39  没有显示名称  阅读(397)  评论(0)    收藏  举报