IT博客汇 | MySQL 5.6 Database Administrator-004-When designing an InnoDB table, identify an advantage of using the BIT datatype Instead of one of the integer datatypes.

MySQL 5.6 Database Administrator-004-When designing an InnoDB table, identify an advantage of using the BIT datatype Instead of one of the integer datatypes.

royalwzy发表于 2015-09-01 23:14:45

When designing an InnoDB table, identify an advantage of using the BIT datatype Instead of one of the integer datatypes. A. BIT columns are written by InnoDB at the head of the row, meaning they are always the first to be retrieved. B. Multiple BIT columns pack tightly into a row, using less space. C. BIT (8) takes less space than eight TINYINT fields. D. The BIT columns can be manipulated with the bitwise operators &, |, ~, ^, < <, and >>. The other integer types cannot.