title: Python MySQLdb update query fails
body: <p>Okay. I've built here a mysql query browser, like navicat. Using MySQLdb to perform queries.</p>
  
  <p>Here's the weird part. When i run the query through the program(using MySQLdb), it gives me success, affected rows = 1, but when i look at it in phpmyadmin, the value hasn't changed.</p>
  
  <p>so before i perform the query, i  print it out, copy and paste into phpmyadmin's query window, hit go and it works. So long story short, update query isn't working, but when i copy and paste into phpmyadmin, it works.</p>
  
  <pre><code>self.tbl.sql.use(self.tbl.database)       # switches to correct database. I've printed this and it uses the corrected db
  if self.tbl.sql.execute(query) == True:
      print sql_obj.rows_affected()         # returns 1 (since i only do 1 query)
  </code></pre>
  
  <p>And here's the part of the SQL class</p>
  
  <pre><code>def execute(self, query):
  
      try:
          self.cursor.execute(query)
          return True
      except MySQLdb.ProgrammingError as error:
          print "----&gt;SQL Error: %s" % error
          return False
      except MySQLdb.IntegrityError as e:
          print "---&gt;SQL Error: %s" % e    
          return False
  </code></pre>
  
  <p>So any ideas what could be happening?</p>