Pandas读写Mysql

读取

#连接
conn=pymysql.connect(user='用户名',
                     host='主机',
                     port=3306,
                     password='密码',
                     database='库名',
                     charset='utf8')
sql='select * from info'  #sql语句
#读取
pd.read_sql(sql,conn)

写入

写数据 不能直接使用df.to_sql()否则会报错

#需要安装两个库
pip install mysqlclient
pip install  sqlalchemy

from sqlalchemy import create_engine

host = '127.0.0.1'
port = 3306
db = '库名'
user = '用户'
password = '密码'
engine = create_engine(str(r"mysql+mysqldb://%s:" + '%s' + "@%s/%s?charset=utf8") % (user, password, host, db))
#或者
# engine = create_engine("mysql+pymysql://用户名:密码@主机:3306/库名?charset=utf8")

df.to_sql('peo',engine)