title: Psycopg2 execute values -the query contains more than one '%s' placeholder
body: <p>I'm trying to use psycopg2 execute_values for faster execute and keep getting errors so i guess i'm not writing the sql statement correct.</p>
  <p>That's what i try:</p>
  <pre><code>  sql = &quot;&quot;&quot;UPDATE table SET value1 = %s, value2 = %s, value3 = %s WHERE id = %s&quot;&quot;&quot;
  for feat in features:
      value1=feat.value
      value2=feat.value
      value3=feat.value
  
  
      parameters = [
                  value1,
                  value2,
                  value3,
                 
              ]
      all_parameters.append(parameters)
  
  
  
  execute_values(cur,sql,all_parameters)
  </code></pre>
  <p>i tried using VALUES as well:</p>
  <pre><code> sql=&quot;&quot;&quot;UPDATE table SET (value1,value2,value3) VALUES (%s) WHERE id=%s&quot;&quot;&quot;
  </code></pre>
  <p>This one gave me mostly syntax errors for VALUES</p>
  <p>i'm keep getting : <strong>&quot;the query contains more than one '%s' placeholder&quot;
  or &quot;not all values formatted during string formatting&quot;</strong>  ,&quot; Syntax error in ___&quot;</p>
  <p>How should i write it?</p>