That page is ambiguous about creating a table with enum...


create table account (
ID int auto_increment,
Date date,
Check_Number int(5),
Bank_Match int enum(0,1),
Category varchar(20) no null,
Credit decimal(7,2),
Debit decimal(7,2),
Balance decimal(7,2),
primary key (ID)
);

Didn't work.  

-----Original Message-----
From: Jay Blanchard [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 04, 2004 3:19 PM
To: Scott Hamm; [EMAIL PROTECTED]
Subject: RE: True/False data type


[snip]
What data type should I use to use True/False type when I create a
table?
[/snip]

ENUM http://www.mysql.com/enum

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to