BIN()

Description

This function BIN() returns a string representation of the binary value of N, where N is a longlong (BIGINT) number. Returns NULL if N is NULL.

Syntax

> BIN(N)

Arguments

Arguments	Description
N	Required. UINT Type

Examples

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