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
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
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
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
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
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
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.
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
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
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'
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
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
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
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
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
15 matches
Mail list logo