BIT
This page is part of MariaDB's MariaDB Documentation.
The parent of this page is: Data Types for MariaDB Xpand
Topics on this page:
EXAMPLES
Example of BIT:
CREATE TABLE bit_example (
description VARCHAR(20),
b1 BIT,
b4 BIT(4),
b16 BIT(16)
);
INSERT INTO bit_example VALUES
('Zero', 0, 0, 0),
('One', 1, 1, 1),
('Two', 0, 2, 2),
('Eight', 0, 8, b'1000'),
('All on', 1, 15, b'1111111111111111');
SELECT description, b1+0, LPAD(BIN(b4), 4, 0) AS b4, HEX(b16)
FROM bit_example;
+-------------+------+------+----------+
| description | b1+0 | b4 | HEX(b16) |
+-------------+------+------+----------+
| Zero | 0 | 0000 | 0 |
| One | 1 | 0001 | 1 |
| Two | 0 | 0010 | 2 |
| Eight | 0 | 1000 | 8 |
| All on | 1 | 1111 | FFFF |
+-------------+------+------+----------+
CHANGE HISTORY
Release Series | History |
|---|---|
6.1 |
|
6.0 |
|
5.3 |
|