导入MySQL查询结果:read_sql
import pandas
con = "mysql+pymysql://user:[email protected]/test?charset=utf8mb4"
sql = "SELECT * FROM `student` WHERE id = 2"
# sql查询
df1 = pandas.read_sql(sql=sql, con=con)
print(df1)
import pandas
con = "mysql+pymysql://user:[email protected]/test?charset=utf8mb4"
sql = "SELECT * FROM `student` WHERE id = 2"
# sql查询
df1 = pandas.read_sql(sql=sql, con=con)
print(df1)