Skip to main content
Skip to main content

bin

bin

description

Syntax

STRING bin(BIGINT x) Convert the decimal number x to binary.

example

mysql> select bin(0);
+--------+
| bin(0) |
+--------+
| 0 |
+--------+
mysql> select bin(10);
+---------+
| bin(10) |
+---------+
| 1010 |
+---------+
mysql> select bin(-3);
+------------------------------------------------------------------+
| bin(-3) |
+------------------------------------------------------------------+
| 1111111111111111111111111111111111111111111111111111111111111101 |
+------------------------------------------------------------------+

keywords

BIN