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

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.commit()前con.close()

即

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()