当我在sql中(在Python和Mysql中)运行delete命令时，不要删除记录

Question

以下代码运行时没有出现错误，但数据库没有影响。这意味着该记录不能被删除。Python 中的部分代码

import MySQLdb as msdb
def delete_row(self):
    con = msdb.connect('localhost','root','24434','matab_db')
    cur = con.cursor()
    qq = "DELETE FROM tbl_rezerv_nobat WHERE id=4"
    # or qq = "DELETE FROM tbl_rezerv_nobat WHERE id='4'"
    bb = cur.execute(qq)
    con.close()

感谢

Answer 1

您还应该在con.close() 之前添加con.commit()

即

def delete_row(self):
    con = msdb.connect('localhost','root','24434','matab_db')
    cur = con.cursor()
    qq = "DELETE FROM tbl_rezerv_nobat WHERE id=4;"
    # or qq = "DELETE FROM tbl_rezerv_nobat WHERE id='4'"
    bb = cur.execute(qq)
    con.commit()
    con.close()