[thelist] boolean in MySQL
Howard Cheng
howcheng at ix.netcom.com
Wed Jun 19 16:38:00 CDT 2002
MySQL itself uses the ENUM datatype with values of 'Y' and 'N'. If you look
in the user tables, you'll see the proof.
At 02:20 PM 6/19/2002 -0700, Michael Mell wrote:
>MySQL doesn't have a boolean type, right? So what is the preferred way
>to create a column to hold a true/false value?
>I've been using
> CHAR(1) DEFAULT "N",
>how's that?
::::::::::::::::::::::
Howard Cheng
howcheng at ix.netcom.com
AIM: bennyphoebe
ICQ: 47319315
More information about the thelist
mailing list