title: Pandas Insert data into MySQL
body: <p>I am trying to insert columns of data that I extracted from .csv file into MySQL using Pandas (Python).</p>
  
  <p>Here is my code that I have so far.</p>
  
  <pre><code>import pandas as pd
  from pandas.io import sql
  from sqlalchemy import create_engine
  engine = create_engine('mysql://username:password@localhost/dbname')
  with engine.connect() as conn, conn.begin():
  
  df = pd.read_csv('File.csv', usercols=['ID', 'START_DATE'], skiprows=skip)
  print(df)
  
  df.to_sql(con=con, name='Table1', if_exists='replace', flavor='mysql')
  </code></pre>
  
  <p>But, it does not mention about specific column names in Table1.. </p>
  
  <p>How do we express that?</p>