title: Python MySQLdb Programming Error: 1064 when inserting data
body: <p>I have this list </p>
  
  <pre><code>info=[[u' Rasta.eon 2 - 1 Rasta.Xd   ', u'Razer CS:GO Tournament 2', u'26-02-2014'], [u' XPC 1       - 2 WP.GG  ', u'Roccat DotA 2 Tournament', u'26-02-2014']]
  
  conn= MySQLdb.connect(host='localhost',user='root',passwd='',db='ee')
  
  c = conn.cursor()
  query = "INSERT INTO todaysmatches (match,tournamentname,matchdate) VALUES (%s,%s,%s)"
  c.executemany(query, info)
  conn.commit()
  conn.close()
  </code></pre>
  
  <p>when I try to execute the query I get this error </p>
  
  <pre><code>ProgrammingError: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'match,tournamentname,matchdate) VALUES \n(' Rasta.eon 2 - 1 Rasta.Xd   ','Razer C' at line 1")
  </code></pre>
  
  <p>match is varchar(150),tournamentname is varchar(150),matchdate is DATE</p>