import pandas as pd
import pymysql
a=pymysql.connect(host='127.0.0.1',port=3306,user='root',passwd='123456',db='cas',use_unicode=True, charset="utf8")
sql='select * from tb_user'
d=pd.read_sql(sql,con=a)
print(d)
参考自:
import pandas as pd
import pymysql
a=pymysql.connect(host='127.0.0.1',port=3306,user='root',passwd='123456',db='cas',use_unicode=True, charset="utf8")
sql='select * from tb_user'
d=pd.read_sql(sql,con=a)
print(d)
参考自: