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)