Explain the difference between BOOL, TINYINT and BIT

• BIT data type can store up to 8 bytes from My SQL version 5.0.3
• BIT data type can be used only for binary data

MySQL BOOL, TINYINT and BIT - September 30, 2009 at 18:00 pm by Vidya SagarExplain the difference between BOOL, TINYINT and BIT in MySQL.BOOL: Used to store Boolean values, 0 being false and 1 being true. MySQL sets them as TINYINT type.
TINYINT: The range of this data type is -128 - +127 or 0 – 256 and occupies 1 byte.
BIT: Bit uses 8 bytes and stores only binary data.