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="select * from student where course='bca' "
''''' [SQL query may be changed using python variable instead of fixed value]
course="bca" (python variable).
sql="select * from student where course='%s' " %,(course)
'''
MyCursor.execute(sql)
result=MyCursor.fetchall()
for i in result:
print(i)