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)