方法一:
import pymysql
con = pymysql.connect(host='地址‘’, user='用户名', passwd='密码', db='数据库名', port = 端口,charset = 'GBK')
sql= 'select * from 表格名'
data = pd.read_sql(sql,con)
import pymysql
import pandas as pd
con = pymysql.connect(host='地址‘’, user='用户名', passwd='密码', db='数据库名', port = 端口,charset = 'GBK')
sql= 'select * from 表格名'
data = pd.read_sql(sql,con)
print(data)
方法二:
import pandas as pd
#首次接收到连接请求时建立DBAPI连接的对象
from sqlalchemy import create_engine
self.engine = create_engine( 'mysql+pymysql://用户名:密码@地址/数据库名?charset=utf8')
#按time降序取10000条数据;*代表全部内容
sql="""SELECT * FROM 要读取的表格名 WHERE 条件
ORDER BY time DESC LIMIT 10000"""
df = pd.read_sql_query(sql, self.engine)
print(df)