Updating record

☞ To update a record, we need to perform following steps :

Steps : Import mysql.connector module → Open a connection → Create cursor object → Execute a query →Save the changes using commit( ).

☞ Example :

import mysql.connector as m
mydb = m.connect(host='localhost', user='root', password='in$pireweb$oft', database='school')
cur = mydb.cursor()
print("1. Modify Name\n2. Modify DOB\n3. Modify Gender\n4. Modify Fees")
ch = int(input("Enter your choice : "))
a = int(input("Enter an admission number : "))
if ch==1:
    b = input("Enter a name : ")
    s="UPDATE student SET name = '{}' WHERE Admno = '{}' ".format(b,a)
    cur.execute(s)
                      
OR

    s="UPDATE student SET name = %s WHERE admno = %s"
    rec=(b,a)
    cur.execute(s,rec)

elif ch==2:
    c = input("Enter Date of Birth in [YYYY-MM-DD] format : ")
    s="UPDATE student SET DOB = '{}' WHERE Admno = '{}' ".format(c,a)
    cur.execute(s)
                        
OR

    s="UPDATE student SET DOB = %s WHERE admno = %s"
    rec=(b,a)
    cur.execute(s,rec)

elif ch==3:
    d = input("Enter a gender [M/F] : ")
    s="UPDATE student SET gender = '{}' WHERE Admno = '{}' ".format(d,a)
    cur.execute(s)

OR

    s="UPDATE student SET gender = %s WHERE admno = %s"
    rec=(b,a)
    cur.execute(s,rec)

elif ch==4:
    e = float(input(" Enter your fees : "))
    s="UPDATE student SET Fees = '{}' WHERE Admno = '{}' ".format(e,a)
    cur.execute(s)

OR

    s="UPDATE student SET Fees = %s WHERE admno = %s"
    rec=(b,a)
    cur.execute(s,rec)
else:
    print("Wrong choice!!!")

mydb.commit()
print("Data updated successfully!!!")

☞ Output :


1. Modify Name
2. Modify DOB
3. Modify Gender
4. Modify Fees
Enter your choice : 4
Enter an admission number : 6
Enter your fees : 1500.00
Data updated successfully!!!