how to do a boolean value in MySQL

[WindAndWaves]

Hi Gurus

What is the best way to store a boolean value in a MySql table (e.g. true or false) AND ( ;-) am I asking this in the right
newsgroup (I could not find one for MySQL)

Thank you

- Nicolaas

[Kevin]

From the MySQL manual:

BOOL
BOOLEAN
These are synonyms for TINYINT(1). The BOOLEAN synonym was added in MySQL
4.1.0. A value of zero is considered false. Non-zero values are considered
true. In the future, full boolean type handling will be introduced in
accordance with standard SQL.

"WindAndWaves" <ac****@ngaru.com> wrote in message
news:2R*******************@news.xtra.co.nz...

Hi Gurus

What is the best way to store a boolean value in a MySql table (e.g. true
or false) AND ( ;-) am I asking this in the right
newsgroup (I could not find one for MySQL)

Thank you

- Nicolaas

[News Me]

WindAndWaves wrote:

Hi Gurus

What is the best way to store a boolean value in a MySql table (e.g. true or false) AND ( ;-) am I asking this in the right
newsgroup (I could not find one for MySQL)

Thank you

- Nicolaas

The answer is here: http://dev.mysql.com/doc/