Skip to main content

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)


Comments

Post a Comment

Popular posts from this blog

CS - SORTING/SEARCHING ALGORITHMS

  SORTING ALGORITHMS                       SORTING ALGORITHM PDF LINK #Bubble Sort          ·        The outer loop iterates through the entire array. ·        The inner loop compares adjacent elements and swaps them if they are out of order. ·        The outer loop runs n times, and each pass moves the largest element to its correct position. arr=[3,8,5,2,1] n = len(arr) print(n) for i in range(n):  #traverse through all the elements         # Last i elements are already sorted, no need to check them         for j in range(0, n-i-1):              # Swap if the element found is greater than the next element              if arr[j] > arr[j+1]:               ...
Post a Comment
Read more

GRADE XI - NESTED FOR LOOP

                                                         NESTED FOR LOOP 1. for var1 in range(3):      print(var1,"OUTER LOOP")          # 0 outer loop       1 outer loop      2 outer loop          for var2 in range(2):                  print(var2+1,"INNER LOOP")    #1  2 inner loop     1  2  inner loop   1 2 inner loop  2. Print the following pattern using for loop: 1  1 2  1 2 3  1 2 3 4  Sol: for r in range(1,5):   #ROWS     for c in range(1,r+1):   #COLUMNS         print(c,end=" ")     print() 3. Print the following pattern using for loop: @  @ @  @ @ @...
Post a Comment
Read more