import mysql.connector
db=mysql.connector.connect(
host="localhost",
user="root",
password="root",
database="sharp_tutorial")
print("succecssfully connected with database")
MyCursor=db.cursor()
sql="delete from student where course='bca' " #later we can use variable in where clause
MyCursor.execute(sql)
db.commit()
print("record deleted ")