from django.db import connection
cursor = connection.cursor()
cursor.execute("delete from event where id=%s",[event_id])
cursor.close()
innodb在上面情况下,不会生效,cursor.close() 并没有进行commit操作
两种解决方法:
1,
cursor.execute("commit")
cursor.close()
2,
connection.close()
通过查看代码:
Lib\site-packages\django\db\backends\__init__.py