Scribd
Upload
5 views6 pages

Python MySQL CRUD Operations Guide

The document contains Python code snippets for connecting to a MySQL database and performing CRUD operations on a 'student' table. It includes functions to insert, update, and delete records based on user input, as well as to display records from the table. Each function establishes a connection to the database, executes SQL commands, and handles user interactions for data entry.

Uploaded by

amirthaa.asp2009
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
5 views6 pages

Python MySQL CRUD Operations Guide

The document contains Python code snippets for connecting to a MySQL database and performing CRUD operations on a 'student' table. It includes functions to insert, update, and delete records based on user input, as well as to display records from the table. Each function establishes a connection to the database, executes SQL commands, and handles user interactions for data entry.

Uploaded by

amirthaa.asp2009
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

#python connectivity using select query

import [Link] as db
mycon=[Link](host="localhost",user="root",password="root",d
atabase="school")
if mycon.is_connected()==False:
print("Error in connection")
else:
print("connected")
c=[Link]()
[Link]("select * from student where marks>75")
data=[Link](3)
for i in data:
print(i)
[Link]()

#Write a function to implement the python code to insert the


following
#table-student fields-rno,name,class
import [Link] as db
def display():

mycon=[Link](host="localhost",user="root",password="root",d
atabase="school")
if mycon.is_connected()==False:
print("Error in connection")
else:
print("connected")
c=[Link]()
n=int(input("Enter the number of records:"))
for i in range(n):
rollno=int(input("Enter rollno:"))
name=input("Enter name:")
class=int(input("Enter class:"))
st="insert into student
values({},'{}',{})".format(rollno,name,class)
[Link](st)
print("records inserted")
[Link]()
[Link]()
display()

#Write a function to implement the python code to update the


following
#table-student fields-rno,name,class
#update rollno and [Link] values from user
import [Link] as db
def display():
mycon=[Link](host="localhost",user="root",password="root",
database="school")
if mycon.is_connected()==False:
print("Error in connection")
else:
print("connected")
c=[Link]()

rollno=int(input("Enter rollno:"))
name=input("Enter name:")
st="update student set rno={} where
name='{}'".format(rollno,name)
[Link](st)
print("records updated")
[Link]()
[Link]()
display()
#table-student fields-rno,name,class
#Delete rollno .read values from user
import [Link] as db
def display():

mycon=[Link](host="localhost",user="root",password="root",d
atabase="school")
if mycon.is_connected()==False:
print("Error in connection")
else:
print("connected")
c=[Link]()
rollno=int(input("Enter rollno:"))

st="Delete from student where rno={}".format(rollno)


[Link](st)
print("records deleted")
[Link]()
[Link]()
display()

#prg for inserting the record and display the record


#Write a function to implement the python code to insert the
following
#table-student fields-rno,name,class
import [Link] as db
def display():

mycon=[Link](host="localhost",user="root",password="root",d
atabase="school")
if mycon.is_connected()==False:
print("Error in connection")
else:
print("connected")
c=[Link]()
n=int(input("Enter the number of records:"))
for i in range(n):
rollno=int(input("Enter rollno:"))
name=input("Enter name:")
class=int(input("Enter class:"))
st="insert into student
values({},'{}',{})".format(rollno,name,class)
[Link](st)
print("records inserted")
[Link]()
st1="select * from student"
[Link](st1)
data=[Link]()
for i in data:
print(i)
[Link]()
display()

You might also like