Connecting To MySQL DB

What is MySQL?

import mysql.connector


import pandas as pd


mydb = mysql.connector.connect(host="localhost",user="root",password="Siddhu@1102",database="sem3")

l=mydb.cursor()

l.execute("desc student")

c=l.fetchall()

colname=[]


for t in c:

    colname.append(t[0])




l.execute("SELECT * FROM student")

res=l.fetchall()



df=pd.DataFrame(res,columns=colname)




print(df)