Writing to MySQL database with pandas using SQLAlchemy, to_sql

by

Using the engine in place of the raw_connection() worked:

import pandas as pd
import mysql.connector
from sqlalchemy import create_engine

engine = create_engine('mysql+mysqlconnector://[user]:[pass]@[host]:[port]/[schema]', echo=False)
data.to_sql(name="sample_table2", con=engine, if_exists="append", index=False)

Not clear on why when I tried this yesterday it gave me the earlier error.

More Related Contents:

  1. How to write DataFrame to postgres table
  2. How to convert SQL Query result to PANDAS Data Structure?
  3. How to insert pandas dataframe via mysqldb into database?
  4. SQLAlchemy ORM conversion to pandas DataFrame
  5. How do I get a raw, compiled SQL query from a SQLAlchemy expression?
  6. How to disable SQLAlchemy caching?
  7. memory-efficient built-in SqlAlchemy iterator/generator?
  8. How to build a flask application around an already existing database?
  9. Bulk Insert A Pandas DataFrame Using SQLAlchemy
  10. SQLAlchemy ON DUPLICATE KEY UPDATE
  11. Bulk insert with SQLAlchemy ORM
  12. Python Pandas write to sql with NaN values
  13. ImportError: No module named MySQLdb
  14. Python Pandas to_sql, how to create a table with a primary key?
  15. How to upsert pandas DataFrame to PostgreSQL table?
  16. How to upsert pandas DataFrame to Microsoft SQL Server table?
  17. What’s the difference between MySQLdb, mysqlclient and MySQL connector/Python?
  18. flake8 complains on boolean comparison “==” in filter clause
  19. python pandas to_sql with sqlalchemy : how to speed up exporting to MS SQL?
  20. pandas to_sql all columns as nvarchar
  21. Reverse engineer SQLAlchemy declarative class definition from existing MySQL database?
  22. How to make mysql connection that requires CA-CERT with sqlalchemy or SQLObject
  23. Retrieve query results as dict in SQLAlchemy
  24. pyodbc.connect() works, but not sqlalchemy.create_engine().connect()
  25. Split a large pandas dataframe
  26. Plotting grouped data in same plot using Pandas
  27. Add column with constant value to pandas dataframe [duplicate]
  28. pivot_table No numeric types to aggregate
  29. Python Pandas – Merge based on substring in string
  30. How to update Pandas from Anaconda and is it possible to use eclipse with this last

Leave a Comment