YES/NO in mysql

houssam_ballout · 07-04-2007, 08:33 AM

hello all
I have 3 fields in mysql, these are just Yes/NO as in Access, well in mysql, Do I use binary?
Thanks in advanc

**Cromewell** · 07-04-2007, 08:27 PM

Yes you can use bool for yes/no fields. If you want it to actually say Yes/No you could use enum('Yes', 'No') as well

07-04-2007, 08:33 AM	#1 (permalink)
houssam_ballout Diamond Member Join Date: May 2005 Location: here Age: 22 Posts: 1,017	YES/NO in mysql hello all I have 3 fields in mysql, these are just Yes/NO as in Access, well in mysql, Do I use binary? Thanks in advanc __________________ TechNoloGy ConTrols tHe World AnD I conTroL the TecHnOl0gy Gue$s WhO @m i. HehEhehee :confused:

07-04-2007, 08:27 PM	#2 (permalink)
Cromewell Moderator Join Date: Dec 2004 Location: Canada Age: 25 Posts: 10,115	Yes you can use bool for yes/no fields. If you want it to actually say Yes/No you could use enum('Yes', 'No') as well __________________ You know what the chain of command is? It's the chain I go get and beat you with 'til ya understand who's in ruttin' command here. I must plug a couple comics because they are good :D: www.ctrlaltdel-online.com www.userfriendly.org

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
upgrading to mysql 5	houssam_ballout	General Software	0	11-29-2006 10:46 AM
Help setting up a web server using CGI & Mysql	Southy	Computer Networking and Servers	1	09-14-2006 05:27 PM
MYSqL	houssam_ballout	General Software	2	12-06-2005 07:14 AM
PHP - add record to MySQL data source	dragon2309	General Software	4	10-31-2005 06:42 PM
MySQL Control Center	dragon2309	Internet Discussion	2	10-18-2005 06:12 PM