Check sibling questions
Computer Science - Class 12
Chapter 15 - Interface of Python with SQL Database

Consider table ‘Faculty’ in database EngColl with following structure.

Id                -    Faculty id. (Primary Key)

lastname    -    Lastname of the faculty member

Firstname   -    Firstname of the faculty member

locationid   -    Location id of the member.

phone         -    Phone Number of the member.

rank            -    It can be either ‘ASSO’, ‘FULL’,

‘ASST’, ‘INST’

startdate    -   date of joining of the member. Write a Python code to update the rank of the member as ‘FULL’ for all the records whose data of joining is before 31/3/1998.

Password of database is pwdfac, and userid is Fac_ dep

 

Answer:

import mysql.connector

 

mydb = mysql.connector.connect('localhost','Fac_dep','pwdfac','EngColl')

cursor = mydb.cursor()

sql = "UPDATE faculty set rank='FULL' where startdate<'1998-03-31';"

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.