from pandas import *
import pandas as pd
from sqlalchemy import create_engine
engine = create_engine("mysql+pymysql://root:wenwajiao@127.0.0.1:3306/ryandb?charset=UTF8MB4")
#charset设置用于mysql8.0的新型字符集，清根据你的需要设定
print(engine)
myframe = pd.read_sql("select colname,comment,tblbelongs from colname",con=engine)
print (myframe)
从mysql8.0读取数据并形成pandas dataframe类型数据
原文：https://www.cnblogs.com/saintdingspage/p/11390404.html