title: How to insert pandas dataframe via mysqldb into database?
body: <p>I can connect to my local mysql database from python, and I can create, select from, and insert individual rows.</p>
  
  <p>My question is: can I directly instruct mysqldb to take an entire dataframe and insert it into an existing table, or do I need to iterate over the rows? </p>
  
  <p>In either case, what would the python script look like for a very simple table with ID and two data columns, and a matching dataframe?</p>