pandas的DataFrame数据,使用
df.to_sql接口时,
from sqlalchemy import create_engine
# 使用SQLAlcheymy的ORM框架,链接数据库
engine = create_engine( "mysql+pymysql://%s:%s@%s:%s/%s?charset=utf8" % ("user", "pwd", "192.168.0.100", 3306, "testdatabase"),
df.to_sql( "TestTable", con=engine, schema="testdatabase", if_exists="replace", index=False )
提示错误
"in %r%s: (%s)" % (bind.engine, s, ", ".join(missing))
sqlalchemy.exc.InvalidRequestError: Could not reflect: requested table(s) not available in Engine(mysql+pymysql://root:***@192.168.0.102:3306/testdatabase?charset=utf8) schema 'testdatabase': (TestTable)
后来发现是表名大小写问题,表名大写就会出现报错,小写就可以正常创建数据库。