title: Write pandas dataframe to MySQL
body: <p>I've got some weird problem here and stuck. I'm rewriting python script that generates some CSV files, and I need to write the same info on MySQL server.</p>
  
  <p>I've managed to get it working... somehow.</p>
  
  <p>Here is the part that creates CSV: </p>
  
  <pre><code>final_table.get_tunid_town_pivot().to_csv('result_pivot_tunid_town_' + ConsoleLog.get_curr_date_underline() + '.csv', sep=';')
  </code></pre>
  
  <p>And here is the part that loads data into MySQL table:</p>
  
  <pre><code>conn = pymysql.connect(host='localhost', port=3306, user='test', passwd='test', db='test')
  final_table.get_tunid_town_pivot().to_sql(con=conn, name='TunID', if_exists='replace', flavor='mysql', index=False, chunksize=10000)
  conn.close()
  </code></pre>
  
  <p>The problem is that there are 4 columns in dataframe, but in MySQL i get only one last column. I have no idea why is that happening, and I found zero similar problems. Any help please?</p>