set your column something like: enum('0','1');
Curtis
On Fri, 2 Mar 2001, Scott Dunn wrote:
> I want to have like in Access a column that is yes or no or true or false,
> something on that line. I looked at www.mysql.com but could not find
> anything. I don't know what exactly I am looking for
Hi,
> I am trying to insert this into my table but mysql doesn't like my syntax.
>
> alter table categoryminor solvalveyn enum('True','False');
You missed something from the query. It should be:
ALTER TABLE categoryminor ADD COLUMN solvalveyn ENUM('True', 'False');
^^
uot;0" as false, if you prefer Y and N then here's a perfect solution.
>
> Cheers
> Jon
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: 02 March 2001 14:32
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Sub
Hi,
> I want to have like in Access a column that is yes or no or true or false,
> something on that line. I looked at www.mysql.com but could not find
> anything. I don't know what exactly I am looking for. Could someone give me
> a hand it will be greatly appreciated.
The ENUM field type will
On Fri, 2 Mar 2001 14:00:21 - , Jon Haworth <[EMAIL PROTECTED]>
wrote:
You can use the datatype:
col_name ENUM('True','False') # True or False
or
col_name SET('True','False') # only these value will be excepted
>>I usually use a tinyint with a value of 1 for true, and 0 for false. There
>>do
I usually use a tinyint with a value of 1 for true, and 0 for false. There
doesn't appear to be a boolean datatype in MySQL, but I may have missed it
:-)
HTH
Jon
-Original Message-
From: Scott Dunn [mailto:[EMAIL PROTECTED]]
Sent: 02 March 2001 13:55
To: Mysql
Subject: yes/no
I want
