RE: MySQL Checkbox table field

2002-01-25 Thread Paul DuBois
mmerce Project Manager >Mountain Top Herbs > > >-Original Message- >From: Paul DuBois [mailto:[EMAIL PROTECTED]] >Sent: Friday, January 25, 2002 2:02 PM >To: Matthew Walker; [EMAIL PROTECTED] >Subject: RE: MySQL Checkbox table field > >At 14:04 -0700 1/25/02, Mat

RE: MySQL Checkbox table field

2002-01-25 Thread Matthew Walker
ed on that table. Matthew Walker Ecommerce Project Manager Mountain Top Herbs -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Friday, January 25, 2002 2:02 PM To: Matthew Walker; [EMAIL PROTECTED] Subject: RE: MySQL Checkbox table field At 14:04 -0700 1/25/02, Ma

Re: MySQL Checkbox table field

2002-01-25 Thread David Shields
Alright then! > database,sql,query,table Which field type do I use for a simply checkbox Y,N? Thanks Any objection to this ? cbcolumn enum ('Y', 'N') NOT NULL DEFAULT 'Y' May not be the most space efficient, but its clear, self-documented and unambiguous. It does what it says on the tin. Da

RE: MySQL Checkbox table field

2002-01-25 Thread Paul DuBois
At 14:04 -0700 1/25/02, Matthew Walker wrote: >This brings to mind a question I've had for a while. Is there any way to >automatically build and update an enum based on another very simple (1 >column) table? What does that mean, exactly? > >Matthew Walker >Ecommerce Project Manager >Mountain Top

RE: MySQL Checkbox table field

2002-01-25 Thread Matthew Walker
EMAIL PROTECTED]] Sent: Friday, January 25, 2002 1:45 PM To: Vernon A Webb; [EMAIL PROTECTED] Subject: RE: MySQL Checkbox table field I've been using enum ("Y","N"). James -Original Message- From: Vernon A Webb [mailto:[EMAIL PROTECTED]] Sent: Friday, January 25, 2002

RE: MySQL Checkbox table field

2002-01-25 Thread James E. Hicks III
I've been using enum ("Y","N"). James -Original Message- From: Vernon A Webb [mailto:[EMAIL PROTECTED]] Sent: Friday, January 25, 2002 10:58 AM To: [EMAIL PROTECTED] Subject: Re: MySQL Checkbox table field Alright then! > database,sql,query,table Whi

Re: MySQL Checkbox table field

2002-01-25 Thread Michael Collins
At 12:02 PM -0600 1/25/02, Dan Nelson wrote: >According to the Mysql manual, the bit type was added in 3.21.12. >`BIT' `BOOL' `CHAR' > These three are synonyms for `CHAR(1)'. I see that now in the online docs, I am using the pdf, guess it is not as up to date. Sorry if I spoke out of turn.

Re: MySQL Checkbox table field

2002-01-25 Thread Dan Nelson
In the last episode (Jan 25), Michael Collins said: > At 11:32 AM -0600 1/25/02, Dan Nelson wrote: > >Why would the MySQL TODO mention an MS SQL feature? :) > > Because the MySQL team wants to add a feature that is found in > another DBMS? According to the Mysql manual, the bit type was added in

Re: MySQL Checkbox table field

2002-01-25 Thread Michael Collins
At 11:32 AM -0600 1/25/02, Dan Nelson wrote: >Why would the MySQL TODO mention an MS SQL feature? :) Because the MySQL team wants to add a feature that is found in another DBMS? >OK, so it's actually a synonym for tinyint(1). I could not find a reference to the synonym in the MySQL documenta

Re: MySQL Checkbox table field

2002-01-25 Thread Dan Nelson
In the last episode (Jan 25), Michael Collins said: > At 10:49 AM -0600 1/25/02, Dan Nelson wrote: > > > >Which field type do I use for a simply checkbox Y,N? > > >The BIT type seems to be the best fit. It's currently a synonym for > >CHAR(1), but there's a TODO item: > > > > * Optimise `BIT'

Re: MySQL Checkbox table field

2002-01-25 Thread Michael Collins
At 10:49 AM -0600 1/25/02, Dan Nelson wrote: > > >Which field type do I use for a simply checkbox Y,N? >The BIT type seems to be the best fit. It's currently a synonym for >CHAR(1), but there's a TODO item: > >* Optimise `BIT' type to take 1 bit (now `BIT' takes 1 char). Are you thinking M

Re: MySQL Checkbox table field

2002-01-25 Thread Dan Nelson
In the last episode (Jan 25), Michael Collins said: > At 10:58 AM -0500 1/25/02, Vernon A Webb wrote: > > > database,sql,query,table > > > >Which field type do I use for a simply checkbox Y,N? > > How about CHAR(1)? The BIT type seems to be the best fit. It's currently a synonym for CHAR(1), bu

RE: MySQL Checkbox table field

2002-01-25 Thread Todd Williamsen
VarChar Usually -Original Message- From: Vernon A Webb [mailto:[EMAIL PROTECTED]] Sent: Friday, January 25, 2002 9:58 AM To: [EMAIL PROTECTED] Subject: Re: MySQL Checkbox table field Alright then! > database,sql,query,table Which field type do I use for a simply checkbox

Re: MySQL Checkbox table field

2002-01-25 Thread Michael Collins
At 10:58 AM -0500 1/25/02, Vernon A Webb wrote: > > database,sql,query,table > >Which field type do I use for a simply checkbox Y,N? How about CHAR(1)? -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED] ||| Seattle, WA, USA ||| htt

Re: MySQL Checkbox table field

2002-01-25 Thread Vernon A Webb
Alright then! > database,sql,query,table Which field type do I use for a simply checkbox Y,N? Thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (th