【pandas】读写数据库

安装相关模块

pip install mysql-connector
pip install pymysql
pip install sqlalchemy

1.导入相关模块

import pymysql
from sqlalchemy import create_engine
import pandas as pd
pymysql.install_as_MySQLdb()

2.读数据库

conn = create_engine('mysql+pymysql://[user]:[password]@[host]:[port]/[database]', echo=False)
df = pd.read_sql('SELECT * FROM test1', conn )

3.写数据库

df.to_sql(name="test2",con=conn,if_exists = 'append', index=False)