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/
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 |||
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 Y,N
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), but there's
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 MS SQL
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' type to take
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
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 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.
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
Which field type do I use for a simply
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 10:58 AM
To: [EMAIL PROTECTED
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 Herbs
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.
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, Matthew
14 matches
Mail list logo