☞ To delete a record, follow the given examples :
☞ Example :
import mysql.connector as m
mydb = m.connect(host='localhost', user='root', password='in$pireweb$oft', database='school')
cur = mydb.cursor()
a = int(input("Enter an admission number : "))
s="DELETE FROM student WHERE Admno = '{}' ".format(a)
cur.execute(s)
OR
s="DELETE FROM student WHERE Admno = %s "
rec=(a,) #must be list, tuple or dict
cur.execute(s,rec)
mydb.commit()
print("Data deleted successfully!!!")
☞ Output :
Enter fees : 1550
Enter gender[M/F] : M
(1, 'aruna', datetime.date(2010, 5, 21), 'M', Decimal('1500.52'))
No. of records = 1