Dozens of attempts to update the deletion field, but to no avail. Below are some of my attempts. Please help in resolving this problem

  Kiến thức lập trình

Dozens of attempts to update the deletion field, but to no avail. Below are some of my attempts. Please help in resolving this problem.

            sql = "UPDATE drivers SET delete =%s WHERE name=%s"
            val = ("1", "علي صالح محمد حسين")
            self.cur.execute(sql, val)
            self.db.commit()

            sql = "UPDATE drivers SET delete =%s WHERE name=%s"
            self.cur.execute(sql, driver_data)
            self.db.commit()

            sql = "UPDATE drivers SET delete ='1' WHERE name=%s"
            val = ("1", driver_data)
            self.cur.execute(sql, driver_data)
            self.db.commit()

            sql = '''UPDATE drivers SET delete ="1" WHERE name=%s'''
            self.cur.execute(sql, driver_data)
            self.db.commit()

            sql = '''UPDATE drivers SET delete ="1" WHERE name=%s'''
            self.cur.execute(sql, [(driver_data)])
            self.db.commit()

enter image description here

The previous image shows the deletion field that I want to update

New contributor

محمد العياني is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

LEAVE A COMMENT