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

1. > BIN(N)

Arguments

Examples

1. > SELECT bin(1314);
2. +-------------+
3. | bin(1314)   |
4. +-------------+
5. | 10100100010 |
6. +-------------+
7. 1 row in set (0.01 sec)

9. > select bin(2e5);
10. +--------------------+
11. | bin(2e5)           |
12. +--------------------+
13. | 110000110101000000 |
14. +--------------------+
15. 1 row in set (0.00 sec)