Inserting boolean value into MySQL with Python

Question

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))

Gerrat · Accepted Answer · 2011-08-23 05:27:34Z

3

See the MySQL docs. A "Boolean" datatype will just be 0 or 1.

The behavior you're seeing is expected.

answered Aug 23, 2011 at 5:27

Gerrat

29.9k9 gold badges78 silver badges104 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Sravan Kumar · Accepted Answer · 2020-02-03 18:44:41Z

3

For Python 2.7 and MySQLdb package it works for me in this way.

For columns of varchar type use '%s'
For or boolean, number use just %s, %d, %i.

INSERT INTO table (string, bool) VALUES ('%s',%s) % ('string',True)`

edited Feb 3, 2020 at 18:44

Sravan Kumar

1,4573 gold badges19 silver badges42 bronze badges

answered Sep 3, 2015 at 11:27

Michal

312 bronze badges

Comments

BobZombiE · Accepted Answer · 2019-06-18 17:54:04Z

2

if the value is True or False in python you can use int()

>>> a = True
>>> int(a)
1
>>>

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

answered Jun 18, 2019 at 17:54

BobZombiE

1162 silver badges5 bronze badges

Collectives™ on Stack Overflow

Inserting boolean value into MySQL with Python

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related