Check sibling questions
Computer Science - Class 12
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()

 

983 students joined Teachoo Black. What are you waiting for?

Davneet Singh's photo - Teacher, Engineer, Marketer

Made by

Davneet Singh

Davneet Singh is a graduate from Indian Institute of Technology, Kanpur. He has been teaching from the past 12 years. He provides courses for Maths and Science at Teachoo.