title: Inserting python variables into MySQL syntax problems
body: <p>Can someone tell me what's wrong with this Syntax?</p>
  
  <pre><code>&gt;&gt;&gt;y = 14
  &gt;&gt;&gt; cursor.execute("INSERT INTO accounts VALUES ('Bobby', %s)", (y))
  Traceback (most recent call last):
    File "&lt;stdin&gt;", line 1, in &lt;module&gt;
    File "/Library/Python/2.7/site-packages/mysql/connector/cursor.py", line 477, in execute
      stmt = operation % self._process_params(params)
    File "/Library/Python/2.7/site-packages/mysql/connector/cursor.py", line 355, in      
  _process_params
      "Failed processing format-parameters; %s" % err)
      mysql.connector.errors.ProgrammingError: Failed processing format-parameters; argument   
      2 to map() must support iteration
  </code></pre>