Actually, the ideal type for boolean operations is TINYINT(1), which, according to the MySQL Column Types page, is the equivalent of a BOOL or BIT column. http://www.mysql.com/doc/en/Column_types.html
Edward Dudlik Becoming Digital www.becomingdigital.com ----- Original Message ----- From: "Kieran Kelleher" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, 02 June, 2003 16:23 Subject: RE: general questions Define the field as type ENUM [NOT NULL] with values "N" and "Y", but read and understand the ENUM type before you use it so you understand what happens when someone tries to insert something other than Y or N. ENUM (Y/N) is what MySQL uses in the mysql permissions database. So, examine some of these tables if you like by performing an EXPLAIN table or SHOW CREATE TABLE table http://www.mysql.com/doc/en/ENUM.html -----Original Message----- From: Darryl Hoar [mailto:[EMAIL PROTECTED] Sent: Monday, June 02, 2003 3:58 PM To: [EMAIL PROTECTED] Subject: general questions Greetings, I am trying to figure out how to define a field type as boolean. Is there a way? Or must I define the field as integer and represent true/false with 1/0 ? I have a schema defined for a database. I would like to copy that schema to another database. Is there a simple way to accomplish this ? thanks for the info, Darryl -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
