title: How to use MySQL executemany to update list of lists in Python?
body: <p>I have a list of lists : <code>myList = [[123, 345], [23, 45], [54, 34]]</code></p>
  
  <p>I want to do something like this : </p>
  
  <pre><code>cursor.executemany("update tablename set flag = 'yes' where id = %s and officeid = %s", myList)
  </code></pre>
  
  <p>I searched for this and found no solution. If it will never be implemented, what is a better update statement without having to loop through all the elements in the list?</p>