[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