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]

Re: how to do a boolean value in MySQL

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.

"WindAndWav es" <access@ngaru.c om> wrote in message
news:2RjHd.9229 $mo2.698889@new s.xtra.co.nz...[color=blue]
> 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
>
>[/color]

[News Me]

Re: how to do a boolean value in MySQL

WindAndWaves wrote:[color=blue]
> 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
>
>[/color]

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