0

I have tried three of them below. But nothing works.

Error: - TypeError: Invalid argument(s) 'fast_executemany' sent to create_engine(), using configuration MSDialect_pyodbc/QueuePool/Engine. Please check that the keyword arguments are appropriate for this combination of components.

engine = create_engine('mysql+pyodbc://{DB}:{Password}@{server}', fast_executemany=True)
engine = create_engine('mysql+mysqlconnector://{DB}:{Password}@{server}', fast_executemany=True)
engine = create_engine('mysql+pymysql://{DB}:{Password}@{server}', fast_executemany=True)
Alive to die - Anant
  • 70,531
  • 10
  • 51
  • 98
Amit Sharma
  • 1
  • 2

1 Answers1

0

Apparently, the 'fast_executemany' parameter only works with MSSQL, not MySQL. I was running into the same issue and found more information here, https://stackoverflow.com/a/66339461/21364405 .

DirtyDan
  • 11
  • 1
  • 4