首先推荐一个大神的文章,SQLAlchemy 使用经验,对sqlalchemy总结的很好
前提:
python3.6版本 提前安装了模块pandas,sqlalchemy,pymysql
mysql提前在数据库mysql中建好表ootest1228
csv文件:
代码:
# -*- coding: utf-8 -*-
import importlib,sys
importlib.reload(sys)
import pandas as pd
from sqlalchemy import create_engine
from sqlalchemy.orm import sessionmaker
DB_CONNECT_STRING = 'mysql+pymysql://root:1900@localhost/mysql?charset=utf8'
engine = create_engine(DB_CONNECT_STRING, echo=True)
DB_Session = sessionmaker(bind=engine)
session = DB_Session()
csv_data = pd.read_csv('abc.csv',encoding='utf-8')
print(csv_data.shape)
pd.io.sql.to_sql(frame=csv_data,name='00test1228',con=engine,index=Fals