Connecting To MySQL DB
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)