https://dev.mysql.com/doc/refman/5.7/en/bit-type.html
The BIT data type is used to store bit values. A type of BIT( enables storage of M)M-bit values. M can range from 1 to 64.
To specify bit values, b' notation can be used. value'value is a binary value written using zeros and ones. For example, b'111' andb'10000000' represent 7 and 128, respectively. See Section 10.1.5, “Bit-Value Literals”.
If you assign a value to a BIT( column that is less than M)M bits long, the value is padded on the left with zeros. For example, assigning a value of b'101' to a BIT(6) column is, in effect, the same as assigning b'000101'.