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