title: python execute many with "on duplicate key update"?
body: <p>I am trying to executemany in python with on duplicate key update, with the following script:</p>
  
  <pre><code># data from a previous query (returns 4 integers in each row)
  rows = first_cursor.fetchall()
  
  query="""
  INSERT INTO data (a, b, c)
  VALUES (%s,%s,%s) ON DUPLICATE KEY UPDATE a=%s
  """
  second_cursor.executemany(query,rows)
  </code></pre>
  
  <p>I'm getting this error:</p>
  
  <pre><code>File "/usr/lib/pymodules/python2.6/MySQLdb/cursors.py", line 212, in executemany
    self.errorhandler(self, TypeError, msg)
  File "/usr/lib/pymodules/python2.6/MySQLdb/connections.py", line 35, in defaulterrorhandler
    raise errorclass, errorvalue
  TypeError: not all arguments converted during string formatting
  </code></pre>
  
  <p>Is this even possible without creating my own loop?</p>