使用to_sql方法,需要用create_engine, 而不是pymysql.connect,否则就会报如下错误DatabaseError,
#报错:DatabaseError: Execution failed on sql ‘SELECT name FROM sqlite_master WHERE type=‘table’ AND name=?;’: not all arguments converted during string formatting
from sqlalchemy import create_engine
engine = create_engine('mysql+pymysql://root:xxxxxx@xxxx:3306/testdb?charset=utf8')
test.to_sql('test_table', engine, index=False, if_exists='append')