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

Write Python code to create a table Faculty with following fields.

Id, LastName, FirstName, LocationId, phone, rank, startdate

Rank should be one of the following

ASSO, FULL, ASST, INST

Answer:

import mysql.connector.connect

db=mysql.connector.connect('localhost','root','root','College')

cursor=db.cursor()

sql="create table Faculty(Id int,LastName varchar(15),FirstName

varchar(15),LocationId int,phone int,rank varchar(4) check(rank

IN('ASSO','FULL','ASST','INST')),startdate date)"

try:

cursor.execute(sql)

db.commit()

except:

db.rollback()

db.close()