Thread: Boolean Value

  1. No Profile Picture
    Devshed Newbie (0 - 499 posts)
    Does MySQL have a boolean (true/false) datatype?

  2. #2
  3. No Profile Picture
    Devshed Newbie (0 - 499 posts)
    could try enum('0','1')


    <cut from >

    I think you should use and tinyint(1) for this until MySQL has the BIT
    type. This will optimized to take up only one bit in the table.


Similar Threads

  1. Return type for boolean functions in C
    By techgal in forum C Programming
    Replies: 3
    Last Post: October 22nd, 2003, 01:58 AM
  2. how to assing cdrom in shell
    By wyldKard in forum Visual Basic Programming
    Replies: 4
    Last Post: October 19th, 2003, 11:59 AM
  3. boolean full text search not working as expected
    By bakedbean in forum MySQL Help
    Replies: 0
    Last Post: May 8th, 2003, 12:14 PM
  4. Replies: 25
    Last Post: September 30th, 2002, 07:34 PM
  5. what is faster with selecting (boolean or integer)
    By Rooseboom in forum MySQL Help
    Replies: 9
    Last Post: June 7th, 2002, 10:53 AM

IMN logo majestic logo threadwatch logo seochat tools logo