title: Inserting boolean value into MySQL with Python
body: <p>I'm attempting to insert some values into a MySQL table, the first 2 values being string and the last being a boolean value. My problem is that I no matter what I do I can't seem to make python/MySQL recognize the boolean as such and insert it. From what I can tell Python is correctly making the last value a boolean, but MySQL isn't seeing it as such. Each time it just defaults to 0 in the table. Below is some pseudo code that is pretty much what I'm trying to do.</p>
  
  <pre><code>conn = MySQLdb.connect(...)
  c = conn.cursor()
  c.execute("INSERT INTO table (name, string, bool) VALUES (%s,%s,%s,(aName,aString,boolVal))
  </code></pre>