出现事务 不会回滚(数据库引擎已设置为innodb) Python版本(2.7.12)
#connectionimport MySQLdbconn = 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() |
免责声明：本内容仅代表回答会员见解不代表天盟观点，请谨慎对待。
版权声明：作者保留权利，不代表天盟立场。
|
|
|
|
|
|
|
|
天盟APP下载
