How do you put boolean values in MySQL - PHPBuilder Forums

PHP Help PHP Newbies
How do you put boolean values in MySQL

MMythic_Fr0st
Dec 10, 2006
Post #1 Sunday, December 10, 2006 10:46 PM

Im wondering how I would create a place to put a boolean?

(true or false) value

any help plz

Ssneakyimp
Dec 10, 2006
Post #2 Sunday, December 10, 2006 11:06 PM

http://dev.mysql.com/doc/refman/5.0/en/numeric-type-overview.html

NogDog
Dec 11, 2006
Post #3 Monday, December 11, 2006 12:28 AM

Another option is to use an ENUM type field with two enumeration values of your choice: 1 and 2, or "yes" and "no", or "TRUE" and "FALSE", etc.

Write a Reply...

How do you put boolean values in MySQL

Mythic_Fr0st

Im wondering how I would create a place to put a boolean?

(true or false) value

any help plz

sneakyimp

http://dev.mysql.com/doc/refman/5.0/en/numeric-type-overview.html

NogDog

Another option is to use an ENUM type field with two enumeration values of your choice: 1 and 2, or "yes" and "no", or "TRUE" and "FALSE", etc.