MySQL

295 guides

keyboard_arrow_down

Other math topics

Dagster

Pandas

NumPy

Matplotlib

PySpark

MySQL

chevron_leftNumeric

BIT BOOLEAN DECIMAL and NUMERIC FLOAT and DOUBLE TINYINT, SMALLINT, MEDIUMINT, INT, BIGINT

check_circle

Mark as learned

thumb_up

thumb_down

chat_bubble_outline

Comment

auto_stories Bi-column layout

settings

MySQL | BIT

schedule Aug 10, 2023

Last updated

local_offer

MySQL

Syntax

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 8
b'1000'

Example

To create a table with a column that has data type BIT(6):


        
        
            
                
                
                    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         |
+--------------+

Note that 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?

thumb_up

thumb_down

Comment

Citation

Ask a question or leave a feedback...

Official MySQL Documentation

https://dev.mysql.com/doc/refman/8.0/en/bit-type.html

thumb_up

thumb_down

chat_bubble_outline

settings

Enjoy our search

Hit / to insta-search docs and recipes!