w3resource
MYSQL Tutorial

MySQL BIN() function

BIN() function

MySQL BIN() returns the corresponding string representation of the binary value of a BIGINT number. It returns NULL if the number is NULL. The equivalent of BIN() is CONV(N,10,2), where N is a BIGINT number.

Syntax:

BIN(num1)

Argument

Name Description
num1 A number whose BINARY value is to be retrieved.

MySQL Version: 5.6

Video Presentation

Your browser does not support HTML5 video.

Example: MySQL BIN() function

The following MySQL statement returns the string representation of 255, i.e. '11111111'.

Code:

SELECT BIN(255);

Sample Output:

mysql> SELECT BIN(255);
+----------+
| BIN(255) |
+----------+
| 11111111 | 
+----------+
1 row in set (0.01 sec)

All String Functions

MySQL String Functions, slide presentation


ankara escort
kızılay escort