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 fieldVernon A Webb25 Jan
Re: MySQL Checkbox table fieldMichael Collins25 Jan
  • Re: MySQL Checkbox table fieldDan Nelson25 Jan
    • Re: MySQL Checkbox table fieldMichael Collins25 Jan
      • Re: MySQL Checkbox table fieldDan Nelson25 Jan
        • Re: MySQL Checkbox table fieldMichael Collins25 Jan
          • Re: MySQL Checkbox table fieldDan Nelson25 Jan
            • Re: MySQL Checkbox table fieldMichael Collins25 Jan
RE: MySQL Checkbox table fieldTodd Williamsen25 Jan
RE: MySQL Checkbox table fieldJames E. Hicks III25 Jan
RE: MySQL Checkbox table fieldMatthew Walker25 Jan
  • RE: MySQL Checkbox table fieldPaul DuBois25 Jan
Re: MySQL Checkbox table fieldDavid Shields25 Jan
RE: MySQL Checkbox table fieldMatthew Walker25 Jan
  • RE: MySQL Checkbox table fieldPaul DuBois25 Jan