Python MySQL

MySQL Delete

Deleting data

MySQL Delete

You can delete records from an existing table by using the "DELETE FROM" statement.

Delete Record

sql = "DELETE FROM customers WHERE address = 'Mountain 21'"
mycursor.execute(sql)
mydb.commit()