PYTHON - MYSQL CONNECTIVITY CODE

 

#INSERTION OF DATA

import mysql.connector

mydb = mysql.connector.connect(

host="localhost",

user="root",

passwd="root",

database="school"

)

print("Successfully Connected")

#print(mydb)

mycursor=mydb.cursor()

 

v1=int(input("enter ID:"))

v2=input("enter name:")

v3=input("enter Gender:")

v4=int(input("enter age:"))

sql='insert into TEACH values("%d","%s","%s","%s")'%(v1,v2,v3,v4)

print(sql)

mycursor.execute(sql)

mydb.commit()

print("record added")

#MYSQL Connection code – Deletion on database

SOURCE CODE:

s=int(input("enter id of TEACHER to be deleted:"))

r=(s,)

v="delete from TEACH where id=%s"

mycursor.execute(v,r)

mydb.commit()

print("record deleted")

MYSQL Connection code – Updation on database

SOURCE CODE:

import mysql.connector

mydb = mysql.connector.connect(

host="localhost",

user="root",

passwd="root",

database="school"

)

print("Successfully Connected")

print(mydb)

mycursor=mydb.cursor()

v1=int(input("enter ID"))

v2=input("enter name:")

v3=input("enter gender:")

v4=int(input("enter age:"))

updt='update TEACH SET name=%s,gender=%s,age=%s where ID=%s'

data=(v2,v3,v4,v1)

mycursor.execute(updt,data)

mydb.commit()

print(mycursor.rowcount,"record updated successfully")

MYSQL Connection code – Display/Fetch records from database

SOURCE CODE:

q="select * from TEACH"

mycursor.execute(q)

result=mycursor.fetchall()

print("ID,name,gender,age")

for x in result:

    print(x)