Pandas 连接数据库

# 关系型的数据库mysql读写操作
import pymysql

conn = pymysql.connect(host = 'localhost',port = 3306,user = 'root',password = 'root',db = 'dushu',charset = 'utf8')

# 创建了连接，pandas进行数据的读取
df = pd.read_sql('select * from books',con = conn)
display(df.shape,df.head())

# ！！！向mysql存储数据的时候，需要数据库的引擎
from sqlalchemy import create_engine

# mysql-python
conn = create_engine('mysql+mysqldb://softpo:root@localhost:3306/database?charset=utf8')

df.to_sql('books3',con = conn,if_exists='append')