title: Python SQL syntax error
body: <p>Im trying to run a python script on my raspberry pi, in order to store the data that I receive from the gps receiver into a sql table. While Im executing this script I'm getting an error on this part of the code:</p>
  
  <pre><code>sql = "INSERT INTO gps (n_lat, w_long, date_time) VALUES (%s, %s, %s)" % (north, west, t,)
  print sql
  cur.execute(sql)
  print "Rows inserted: %s" % cur.rowcount
  con.commit()
  time.sleep(0.5)
  </code></pre>
  
  <p>Error:</p>
  
  <pre><code>Traceback (most recent call last):
  File "gps.py", line 48, in &lt;module&gt;
    cur.execute(sql)
  File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 174, in execute
    self.errorhandler(self, exc, value)
  File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler raise errorclass, errorvalue
  _mysql_exceptions.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 ':01:16)' at line 1")
  </code></pre>
  
  <p>I don't really understand where is the problem, Have you got any ideas why whiz error occurs ?</p>