title: How to prevent use of the first row Pandas DataFrame as column names when using to_sql
body: <p>I have a dataframe loaded from a CSV file, which includes a header row. After assigning the returned dataframe from read_csv, I'm trying to add the rows to a MySQL database table using SQLAlchemy engine, my method call looks like this:</p>
  
  <pre><code>my_dataframe.to_sql(name="my_table",
                      con=alch_engine,
                      if_exists="append",
                      chunksize=50,
                      index=False,
                      index_label=None)
  </code></pre>
  
  <p>However, the table already exists, and the values of the dataframe header don't match the column names, and so I get a MySQL error (1054, "Unknown Column 'Col1' in 'field_list'")</p>
  
  <p>I would like not to use the first row at all and run the insert query without specifying the column names. I have not found a solution for this from the Pandas manual.</p>
  
  <p>Thank you for your help,</p>