Question

How to delete a record from existing MySQL database table in Python

Answer 1

# c:\Users\user_nm\AppData\Local\Programs\Python\Python35-32\Scripts\pip install mysql-connector
    
import mysql.connector
    
db = mysql.connector.connect(
    host="localhost",
    user="root",
    passwd="",
    database="python_database"
)
   
db_cursor = db.cursor()

sql = "DELETE FROM workers WHERE first_name = %s"
fn = ("Ben", )

db_cursor.execute(sql, fn)

db.commit()

print(db_cursor.rowcount, "record deleted")

db.close()

 
'''
run:
  
1 record deleted

'''

 

70+ SQL courses for beginners and professionals