to_sql() error querying sqlite_master table when writing to MySQL
Your way is not supported anymore.
con : SQLAlchemy engine or DBAPI2 connection (legacy mode)
Using SQLAlchemy makes it possible to use any DB supported by that library. If a DBAPI2 object, only sqlite3 is supported.
flavor : ‘sqlite’, default None
Deprecated since version 0.19.0: ‘sqlite’ is the only supported option if SQLAlchemy is not used.
Try this?
from sqlalchemy import create_engineimport pandas as pdengine = create_engine("mysql://root:matt123@localhost/ada")con = engine.connect()df = pd.DataFrame(['A','B'],columns=['new_tablecol'])df.to_sql(name='new_table',con=con,if_exists='append')con.close()
Syntax is:
engine = create_engine("mysql://USER:PASSWORD@HOST/DATABASE")
More information about sqlalchemy
can be found here