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语句-->关闭连接
![在这里插入图片描述](https://i-blog.csdnimg.cn/blog_migrate/a36bc03b8bfe53f80790670ffe163e6f.png)
from sqlalchemy import create_engine
engine=create_engine('mysql+pymysql://root:密码@127.0.0.1:3306/库名?charset=utf8')
pd.read_sql(表名,engine)
![在这里插入图片描述](https://i-blog.csdnimg.cn/blog_migrate/f00f611b7b61c3e7aed41ff6428e2856.png)