df = pd.read_sql(sql,con=conn) from sqlalchemy import create_engine import sqlalchemy #engine = create_engine('mysql+pymysql://user:password@localhost/Databasename?charset=utf8') #df = pd.read_sql('tablename', engine) engine = create_engine('mysql+pymysql://root@localhost/awesome?charset=utf8') df.to_sql('tablename', engine)
pandas 读取写入sql
最新推荐文章于 2024-02-15 11:23:42 发布