title: How to Insert Huge Pandas Dataframe in MySQL table with Parallel Insert Statement?
body: <p>I am working on a project where I have to write a data frame with Millions of rows and about 25 columns mostly of numeric type. I am using <a href="https://pandas.pydata.org/pandas-docs/version/0.23.4/generat/pandas.DataFrame.to_sql.html" rel="nofollow noreferrer">Pandas DataFrame to SQL Function</a> to dump the dataframe in Mysql table. I have found this function creates an Insert statement that can insert multiple rows at once. This is a good approach but MySQL has a limitation on the length of query that can be built using this approach.</p>
  
  <p>Is there a way such that insert that in parallel in the same table so that I can speed up the process? </p>