title: How to update entire column with values in list using Sqlite3
body: <p>I have a dataset stored locally in an sqlite3 database.  I extracted a column, performed some operations and now want to replace ALL of the values in the database column.  How can I do this?</p>
  
  <p>The length of the column and the list are guaranteed to be the same length.  I simply want to update the table with the new values.  Is there an easy way to do this all at once?</p>
  
  <p>Using python 2.7</p>
  
  <p>Edited to add:</p>
  
  <p>myList is a pandas series backed by a numpy array of dtype 'object'.  The table column, myCol is text formatted.</p>
  
  <pre><code>In [1]: curr.execute('UPDATE test SET myCol= ?', myList)
  
  ---------------------------------------------------------------------------
  ProgrammingError                          Traceback (most recent call last)
  f:\python\&lt;ipython-input-52-ea41c426502a&gt; in &lt;module&gt;()
  ----&gt; 1 curr.execute('UPDATE test SET myCol = ?', myList)
  
  ProgrammingError: Incorrect number of bindings supplied. The current statement uses 1, and there are 401125 supplied.
  </code></pre>