Inserting boolean value into MySQL with Python
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.

    conn = MySQLdb.connect(...)
    c = conn.cursor()
    c.execute("INSERT INTO table (name, string, bool) VALUES (%s,%s,%s,(aName,aString,boolVal))
Inserting boolean value into MySQL with Python
===

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.

    conn = MySQLdb.connect(...)
    c = conn.cursor()
    c.execute("INSERT INTO table (name, string, bool) VALUES (%s,%s,%s,(aName,aString,boolVal))