pandas，读取或存储DataFrames的数据到mysql中

https://www.cnblogs.com/meitian/p/10502657.html

    from sqlalchemy import create_engine
    import sqlalchemy

    connect_info = 'mysql+pymysql://{}:{}@{}:{}/{}?charset=utf8'.format("root", "123456", "127.0.0.1", "3306",
                                                                        "main_capital")
    engine = create_engine(connect_info)
    df.to_sql(name='daily_main_capital',
                con=engine,
                if_exists='append',
                index=False,
                dtype={'IterationId': sqlalchemy.types.Integer(),
                       'title': sqlalchemy.types.NVARCHAR(length=255)
                       }
                )
    res = pd.read_sql("select * from daily_main_capital", engine)
    print(res)