| List: | General Discussion | « Previous MessageNext Message » | |
| From: | David Shields | Date: | January 25 2002 9:05pm |
| Subject: | Re: MySQL Checkbox table field | ||
| View as plain text | |||
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.
David.
| Thread | ||
|---|---|---|
| • Re: MySQL Checkbox table field | Vernon A Webb | 25 Jan |
| • Re: MySQL Checkbox table field | Michael Collins | 25 Jan |
| • Re: MySQL Checkbox table field | Dan Nelson | 25 Jan |
| • Re: MySQL Checkbox table field | Michael Collins | 25 Jan |
| • Re: MySQL Checkbox table field | Dan Nelson | 25 Jan |
| • Re: MySQL Checkbox table field | Michael Collins | 25 Jan |
| • Re: MySQL Checkbox table field | Dan Nelson | 25 Jan |
| • Re: MySQL Checkbox table field | Michael Collins | 25 Jan |
| • RE: MySQL Checkbox table field | Todd Williamsen | 25 Jan |
| • RE: MySQL Checkbox table field | James E. Hicks III | 25 Jan |
| • RE: MySQL Checkbox table field | Matthew Walker | 25 Jan |
| • RE: MySQL Checkbox table field | Paul DuBois | 25 Jan |
| • Re: MySQL Checkbox table field | David Shields | 25 Jan |
| • RE: MySQL Checkbox table field | Matthew Walker | 25 Jan |
| • RE: MySQL Checkbox table field | Paul DuBois | 25 Jan |
