BIN()

Function Description

BIN() converts N to binary string form. where N is a longlong (BIGINT) number. If N is NULL, NULL is returned.

grammar

> BIN(N)

Parameter definition

Parameters	Description
N	Required parameters. UINT Type

Example

> SELECT bin(1314);
+-----------------+
| bin(1314) |
+-----------------+
| 10100100010 |
+-----------------+
1 row in set (0.01 sec)

> select bin(2e5);
+-------------------------+
| bin(2e5) |
+-------------------------+
| 110000110101000000 |
+-------------------------+
1 row in set (0.00 sec)