title: Pandas sql update efficiently
body: <p>I am using python pandas to load data from a MySQL database, change, then update another table. There are a 100,000+ rows so the UPDATE query's take some time.</p>
  
  <p>Is there a more efficient way to update the data in the database than to use the <code>df.iterrows()</code> and run an <code>UPDATE</code> query for each row?</p>