The BIT data type is used to store bit values.
Bit values are specified in the b'value' format, where value is a sequence of 0s and 1s. For example, b'111' represents the decimal value 7, and b'10000000' represents the decimal value 128.
The syntax is as follows:
BIT[(M)]
M specifies the number of bits per value, with a range of [1, 64]. If M is omitted, it defaults to 1.
When inserting a value into a BIT(M) column, if the inserted value's length is less than M, zeros are padded to the left. For example, inserting b'101' into a BIT(6) column results in b'000101'.