MySQL Bit Data Type Examples

The BIT data type is used to store bit-field values.

bit(n)

The bit(n) enables storage of n-bit values and n can be ranged from 1 to 64. Even though the range is quite big, bit(1) is often used.

Set value to bit(1) column (boolean)

b’value’ notation is used to set value to a column with bit data type.

b'1' //true
b'0' //false

0bvalue notation also can be used.

Related posts:

MySQL UPDATE Examples MySQL DATE, DATETIME, and TIMESTAMP Tutorials Convert Uppercase Characters to Lowercase to Compare Data in MySQL