title: MySQLdb: Operand should contain 1 column(s)
body: <p>I am trying to insert some data into a MySQL database, using Python and MySQLdb. When I execute the following function in my program, MySQL returns error "1241, 'Operand should contain 1 column(s)'"</p>
  
  <p>User, password and database are correct, the table is existing and all rights are granted.</p>
  
  <pre><code>def write_to_mysql(pname, dat, like, reachs, talker, friendsfans):
  ''
      try:
          con = mdb.connect(user='user', passwd='password', host='localhost', db='database');
      except Exception. err:
          print(err)
  
      with con:
  
          cur = con.cursor()
          cur.execute("INSERT INTO fbinsights (page, datum, likes, reach, talking, fanfriends) VALUES( %s, %s, %s, %s, %s, %s)", (pname, dat, like, reachs, talker, friendsfans))
  
      connection.commit()
  </code></pre>
  
  <p>Where's the mistake? </p>
  
  <p>Full traceback:</p>
  
  <pre><code>File "insights.py", line 111, in &lt;module&gt;
      main()
    File "insights.py", line 108, in main
      write_to_mysql(PAGE_NAME, date, likes_atm, reach_day, talking_day, friends_of_fans)
    File "insights.py", line 90, in write_to_mysql
      cur.execute("INSERT INTO fbinsights (page, datum, likes, reach, talking, fanfriends) VALUES( %s, %s, %s, %s, %s, %s)", (pname, dat, like, reachs, talker, friendsfans))
    File "/usr/local/lib/python2.7/site-packages/MySQL_python-1.2.3-py2.7-freebsd-9.0-RELEASE-p3-amd64.egg/MySQLdb/cursors.py", line 174, in execute
      self.errorhandler(self, exc, value)
    File "/usr/local/lib/python2.7/site-packages/MySQL_python-1.2.3-py2.7-freebsd-9.0-RELEASE-p3-amd64.egg/MySQLdb/connections.py", line 36, in defaulterrorhandler
      raise errorclass, errorvalue
  _mysql_exceptions.OperationalError: (1241, 'Operand should contain 1 column(s)')
  </code></pre>