import pandas as pd
import pymysql
import pymysql.cursors
config={'host':'127.0.0.1',
'port':3306,
'user':'root',
'password':'*******',
'db':'test',
'charset':'utf8',
'cursorclass':pymysql.cursors.DictCursor}
con=pymysql.connect(**config)
try:
with con.cursor() as cursor:
sql='select * from employee;'
cursor.execute(sql)
finally:
con.close()
pd.DataFrame(result)
设置连接参数-->连接-->获得游标-->执行sql语句-->关闭连接
from sqlalchemy import create_engine
engine=create_engine('mysql+pymysql://root:密码@127.0.0.1:3306/库名?charset=utf8')
pd.read_sql(表名,engine)