Re: yes/no

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

Re: yes/no

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'); ^^

yes/no

I am trying to insert this into my table but mysql doesn't like my syntax. alter table categoryminor solvalveyn enum('True','False'); When I press enter it does nothing it just goes to a greater than prompt. What I want is for 1 to be true and 0 to be false. What is the syntax that I am needin

Re: RE: RE: yes/no

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

Re: yes/no

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

Re: yes/no

t 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]] &g

RE: yes/no

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

yes/no

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. -

Re: Get 'yes', 'no', or 'either' query ?

Floyd Baker wrote: > > Hi. > > Hey I have been using a query in a search with prioritized criteria. > > In five different qualification fields, the first one filled in would produce > the specific search. Name, City, Zip, (C)enter or (I)ndividual... If name & > city empty and zip filled in, a

Get 'yes', 'no', or 'either' query ?

Hi. Hey I have been using a query in a search with prioritized criteria. In five different qualification fields, the first one filled in would produce the specific search. Name, City, Zip, (C)enter or (I)ndividual... If name & city empty and zip filled in, all that zip would appear. No