title: Python MySQLdb error - what is causing this
body: <p>I am wondering why I am receiving this error:</p>
  
  <pre><code>cmd = "INSERT INTO resulttest (category, value, timestamp) VALUES (" + key + ", " + str(value) + ", " + str(timestamp) + ")"
  c.execute(cmd)
  db.commit()
  
      INSERT INTO resulttest (category, value, timestamp) VALUES (composed, 2, 1343186948.8)
  
  Traceback (most recent call last):
    File "C:/Behavioral Technology/Google Drive/twitterthingv5test.py", line 94, in &lt;module&gt;
      moodParser()
    File "C:/Behavioral Technology/Google Drive/twitterthingv5test.py", line 92, in moodParser
      query()
    File "C:/Behavioral Technology/Google Drive/twitterthingv5test.py", line 37, in query
      main(columns)
    File "C:/Behavioral Technology/Google Drive/twitterthingv5test.py", line 81, in main
      c.execute(cmd)
    File "C:\Python27\lib\site-packages\MySQLdb\cursors.py", line 174, in execute
      self.errorhandler(self, exc, value)
    File "C:\Python27\lib\site-packages\MySQLdb\connections.py", line 36, in defaulterrorhandler
      raise errorclass, errorvalue
  </code></pre>
  
  <p>I believe it has something to do with how I am passing my values to the SQL command.</p>