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 learn.

I the past I have used a Boolean data type for True/False, Yes/No type data.

What data type should be used to achieve the storage of this type of data in
MySQL?

I have bought the reference manual (a good buy IMHO) but so far can't find
the answer.

Regards


Tony Roberts
Mailbox Solutions Ltd
[EMAIL PROTECTED]
01777  700 600


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.389 / Virus Database: 220 - Release Date: 16/09/02




---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to