Question 3 - Past Year - 5 Mark Questions - Chapter 15 - Interface of Python with SQL Database

Write Python code to delete all the records from the Employee table whose age >60 and the table has following fields.

Empid, EmpName, Deptid, age, Payscale

Answer:

import mysql.connector

mydb = mysql.connector.connect('localhost','root','root','EMP')

cursor = mydb.cursor()

sql = "DELETE from Employee where age>60"

try:

mydb.execute(sql)

mydb.commit()

except:

mydb.rollback()

cursor.close()

mydb.close()