出现事务 不会回滚(数据库引擎已设置为innodb) Python版本(2.7.12)

Question

#connection import MySQLdb conn = MySQLdb.Connect(                         host = '127.0.0.1',                         port = 3306,                         user = 'root',                         passwd = '',                         db = 'innodb',                         charset = 'utf8'                         ) cursor = conn.cursor() sql_insert = 'insert into stu (name) values("ddd")' sql_update = "update stu set name='小明dddd' where id=14" sql_delete = 'delete from stu where id=1111' # try: #         #cursor.execute(sql_insert) #         #print cursor.rowcount #         #cursor.execute(sql_update) #         #print cursor.rowcount #         cursor.execute(sql_delete) #         print cursor.rowcount #         conn.commit() # except Exception as e: #     print e #     conn.rollbake() try:     cursor.execute(sql_insert)     print(cursor.rowcount)     cursor.execute(sql_update)     print(cursor.rowcount)     cursor.execute(sql_delete)     print(cursor.rowcount)     conn.commit()            #以上三条操作作为整体单元事务，提交数据 except Exception as e:     print(e)     conn.rollback()          #事务出现异常回滚数据 cursor.close() conn.close()

Answer 1

是不是代码里面没有关闭自动提交