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]
