Explain The Difference Between Bool, Tinyint And Bit. ?

1.	Explain The Difference Between Bool, Tinyint And Bit. ?
Answer» 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. 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.

Answer»

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.

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.

Discussion