check_circleMark as learned
MySQL | BIT
schedule Mar 5, 2023Last updated
Check out the interactive map of data science
BIT data type is used to store bit values.
BIT(M) allows for the storage of M-bit values, where M takes the range 1 to 64. Default is 1.
The notation used for representing bit values is
b'value' where value is the binary value written in 0s and 1s.
-- Bit value notation for 8b'1000'
To create a table with a column that has data type
CREATE TABLE test (column1 BIT(6));Query OK, 0 rows affected (0.01 sec)Query OK, 0 rows affected (0.01 sec)
To add bit value
b'1000' as a record to the above table:
INSERT INTO test (column1) VALUES (b'1000');Query OK, 1 row affected (0.01 sec)Query OK, 1 row affected (0.01 sec)
To check the record inserted:
SELECT bin(column1) FROM test;+--------------+| bin(column1) |+--------------+| 1000 |+--------------+
bin(column1) just allows us to return a binary string representation of the stored value. Retrieving
column1 on its own would return a hexadecimal representation of the value.
Published by Arthur Yanagisawa
Edited by 0 others
Did you find this page useful?
Ask a question or leave a feedback...
Enjoy our search
Hit / to insta-search docs and recipes!