首先推荐一个大神的文章,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 = session