mysql设置不主动提交无效_关闭事务自动提交无效，回滚也无效

我是通过看数据库里面数据确认的。代码比较类似，就这么多

#!/usr/bin/python

from MySQLdb import connect

conn = connect(db="test", user="root", host="localhost", unix_socket="/var/lib/mysql/mysql.sock")

cur = conn.cursor()

sql_insert = "insert into test_table(id,name) values('6','f')"

sql_update = "update test_table set name='A' where id ='1'"

sql_delete = "delete from test_table where id>'4'"

conn.autocommit(False)

try:

cur.execute(sql_insert)

print cur.rowcount

cur.execute(sql_update)

print cur.rowcount

cur.execute(sql_delete)

print cur.rowcount

except Exception as e:

print e

conn.rollback()

cur.close()

conn.close()