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

 

Davneet Singh's photo - Co-founder, Teachoo

Made by

Davneet Singh

Davneet Singh has done his B.Tech from Indian Institute of Technology, Kanpur. He has been teaching from the past 12 years. He provides courses for Maths, Science, Social Science, Physics, Chemistry, Computer Science at Teachoo.