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

Consider the structure of table Doctor given

below

Doctor

Doctor_id(p)

Doctor_Name

Hospital_id(F)

Joining_Date

Speciality

Salary Experience.

Write Python code to create the above table.

Answer:

import mysql.connector

mydb=mysql.connector.connect("localhost","root","root","Hospital")

cursor=mydb.cursor()

sql="create table Doctor(Doctor_id int primary key,Doctor_Name

varchar(20),Hospital_id int foreign key,Joining_dat date,Speciality

varchar(45),Salary int,Experience int)"

cursor.execute(sql)

cursor.close()

mydb.close()