Explain the difference between BOOL, TINYINT and BIT?
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.