RE: True/False data type

2004-11-04 Thread Chris Blackwell
D] Subject: Re: True/False data type Personally I use a tinyint(1) unsigned. Scott Hamm wrote: > What data type should I use to use True/False type when I create a table? > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://

Re: True/False data type

2004-11-04 Thread Michael J. Pawlowsky
Personally I use a tinyint(1) unsigned. Scott Hamm wrote: What data type should I use to use True/False type when I create a table? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: True/False data type

2004-11-04 Thread Jeff Smelser
On Thursday 04 November 2004 02:28 pm, Scott Hamm wrote: > 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) > ); It

Re: True/False data type

2004-11-04 Thread Rhino
- Original Message - From: "Scott Hamm" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, November 04, 2004 3:15 PM Subject: True/False data type > What data type should I use to use True/False type when I create a table? > MySQL 4.1.x includes a column type called Boolean whic

RE: True/False data type

2004-11-04 Thread Jay Blanchard
[snip] That page is ambiguous about creating a table with enum... [/snip] A teeny-tiny bit more digging and you would have found it... `Good` enum('true','false') NOT NULL default 'false' -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://list

RE: True/False data type

2004-11-04 Thread Scott Hamm
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.mysq

RE: True/False data type

2004-11-04 Thread Jay Blanchard
[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]

RE: True/False

2002-11-08 Thread Daevid Vincent
According to http://www.mysql.com/doc/en/Column_types.html BIT & BOOL -- These are synonyms for TINYINT(1). DÆVID. > -Original Message- > From: Oluwagbamila Oyekanmi > > Use the data type BOOL which takes a 1 or 0 character or use > CHAR and then you can use Y or N for Yes/No. Or how

Re: True/False

2002-11-08 Thread Insanely Great
Use enum. Rgds Insane SQLyog - The Definitive Win32 GUI for MySQL http://www.sqlyog.com - Original Message - From: "Tony Roberts" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, November 08, 2002 4:56 PM Subject: True/False > I am new to MySQL and I am attempting a new proje

Re: True/False

2002-11-08 Thread Oluwagbamila Oyekanmi
Use the data type BOOL which takes a 1 or 0 character or use CHAR and then you can use Y or N for Yes/No. Regards, 'Gbamila - Original Message - From: "Tony Roberts" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, November 08, 2002 12:26 PM Subject: True/False > I am new to MyS

RE: True/False

2002-11-08 Thread John Meyer
You could use an integer (0 or 1) or an enum with the values 'y' or 'n' -Original Message- From: Tony Roberts [mailto:troberts@;momuk.com] Sent: Friday, November 08, 2002 4:26 AM To: [EMAIL PROTECTED] Subject: True/False I am new to MySQL and I am attempting a new project to help me lear