D/MySQL
[MySQL] BIN()
yeon.Biju
2020. 4. 8. 12:43
MySQL 문자열 함수와 연산자
BIN()
-
BIN(N)
의 형태
Returns a string representation of the binary value of N. where N is a longlong (BIGINT) number. This is equivalent to CONV(N, 10, 2). Returns NULL if N is NULL.
mysql> SELECT BIN(12) ;
+---------+
| BIN(12) |
+---------+
| 1100 |
+---------+
1 row in set (0.00 sec)