Explain the difference between BOOL, TINYINT and BIT.

Answer 1

Prior to MySQL 5.0.3: those are all synonyms. After MySQL 5.0.3: BIT data type can store 8 bytes of data and should be used for binary data.