Python Pandas直接MySQL建表写数据

1、读取csv文件

cs = pd.read_csv('d:/test.csv',encoding='gbk')

2、连接数据库、建表、写数据

from sqlalchemy import create_engine
import pymysql
 
engine = create_engine("mysql+pymysql://root:password@127.0.0.1:3306/mysql", max_overflow=5)
cs.to_sql('car', con=engine)

3、读取数据库数据

connection = engine.connect()

connection.execute("select * from car").fetchall()