Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

how to do a boolean value in MySQL

0 views
Skip to first unread message

WindAndWaves

unread,
Jan 18, 2005, 9:41:27 PM1/18/05
to
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

unread,
Jan 18, 2005, 9:56:56 PM1/18/05
to
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" <acc...@ngaru.com> wrote in message
news:2RjHd.9229$mo2.6...@news.xtra.co.nz...

News Me

unread,
Jan 18, 2005, 10:01:43 PM1/18/05
to

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

0 new messages