线路应为:
df.to_sql(con=db, name='rsstracker', if_exists='append', flavor='mysql')
但您可能需要使用SQLAlchemy来实现此导出(
doc
)
import pymysql
from sqlalchemy import create_engine
engine = create_engine('mysql+pymysql://<username>:<password>@<host>[:<port>]/<dbname>')
engine.execute("DROP TABLE IF EXISTS rsstracker")
engine.execute("""CREATE TABLE rsstracker(
article_title varchar(255),
article_url varchar(1000),
article_summary varchar(1000))""")
df.to_sql(con=engine, name='rsstracker', if_exists='append', , flavor='mysql')