NAME- SAJID AHMED Roll no-001
Subject: Programming with Python Date: 23/02/2023
Practical-4
Q.1) Open mysql connector in python and display all the databases.
Code:
Output:
Q.2) Create a database kccollege and again show the databases.
Code:
import [Link] as m
db=[Link](host='localhost',user='root', password='admin')
a=[Link]()
[Link]("create database hrcollege")
[Link]("show databases")
for i in a :
print(i)
Output:
1
Q.3) Create a table hotel and show the structure item no, name of the dish, cost, type
Code:
import [Link] as m
db=[Link](host='localhost',user='root', password='admin')
a=[Link]()
[Link]("use hrcollege")
[Link]("create table hotel(item_no int, dish_name varchar(30), cost float, type
varchar(30))")
[Link]("desc hotel")
for i in a :
print(i)
Output:
Q.4) Insert a record into table hotel.
Code:
import [Link] as m
db=[Link](host='localhost',user='root', password='admin')
2
a=[Link]()
[Link]("use hrcollege")
[Link]("insert into hotel values(1,'noodles',290,'main course' )")
[Link]("select * from hotel")
for i in a :
print(i)
Output:
import [Link] as m
db=[Link](host='localhost',user='root', password='admin')
a=[Link]()
[Link]('use hrcollege')
f="insert into hotel (item_no, dish_name, cost, type) values(%s,%s,%s,%s)"
v=(2,'pasta',200,'V')
[Link](f,v)
[Link]()
[Link]("select * from hotel")
r=[Link]()
for i in r :
print(i)
Output:
Q.5) Create a table with roll no, name, marks and percentage.
Code:
import [Link] as m
3
db=[Link](host='localhost',user='root', password='root', database='kccollege')
a=[Link]()
[Link]("create table student (rollno int,name varchar(30), marks float, percentage float)")
[Link]("desc student")
for i in a :
print(i)
Output:
Q.6) Insert into Student table.
Code:
import [Link] as m
db=[Link](host='localhost',user='root', password='root', database='kccollege')
a=[Link]()
[Link]("insert into student values(1,'Jagruti', 400, 85)")
[Link]("select * from student")
for i in a :
print(i)
Output:
Q7]
Code:
import [Link] as m
db=[Link](host='localhost',user='root', password='root',database="kccollege")
4
a=[Link]()
print("[Link]")
print("[Link]")
print("[Link]")
print("[Link]")
s=int(input("Enter choice(1-4):"))
if s==1:
r=int(input("Roll No.:"))
n=input("Name:")
m=int(input("Marks:"))
p=float(input("Percentage:"))
sq="Insert into student1(rollno,name,marks,percentage) values(%s,%s,%s,%s)"
val=(r,n,m,p)
[Link](sq,val)
[Link]()
elif s==2:
r=int(input("Enter Roll No to be updated.:"))
n=input("enter Name:")
m=int(input("enter Marks:"))
p=float(input("enter Percentage:"))
sq="update student1 set name=%s,marks=%s,percentage=%s where rollno=%s;"
val=(n,m,p,r)
[Link](sq,val)
[Link]()
elif s==3:
r=int(input("Enter Roll No to be deleted.:"))
sq="delete from student1 where rollno=%s"
val=(r,)
5
[Link](sq,val)
[Link]()
elif s==4:
r=int(input("Enter Roll No to be displayed.:"))
sq="select * from student1 where rollno=%s"
val=(r,)
[Link](sq,val)
else:
print("Wrong choice")
for i in a:
print(i)
Output:
Q8]
Code:
6
import tkinter as t
w=[Link]()
import [Link] as m
db=[Link](host="localhost",user="root",password="root",database="kccollege")
v=[Link]()
[Link]("400x400")
l1=[Link](text="Roll no:")
[Link](row=1,column=1)
e1=[Link]()
[Link](row=1,column=2)
l2=[Link](text="Name")
e2=[Link]()
[Link](row=2,column=2)
[Link](row=2,column=1)
l3=[Link](text="Marks")
[Link](row=3,column=1)
e3=[Link]()
[Link](row=3,column=2)
l4=[Link](text="Percentage")
[Link](row=4,column=1)
e4=[Link]()
[Link](row=4,column=2)
def sq():
f1=int([Link]())
f2=[Link]()
f3=int([Link]())
f4=float([Link]())
7
a="insert into student1(rollno,name,marks,percentage) values(%s,%s,%s,%s)"
val=(f1,f2,f3,f4)
[Link](a,val)
[Link]()
b1=[Link](text="add",fg="blue",command=sq)
[Link](row=5,column=2)
[Link]()
Output:
8
9