In MySQL, how do we get the string representation of the binary value of a number?

In MySQL, the BIN() function is used to obtain the string representation corresponding to the binary value of a number. It treats numbers as DECIMAL numbers.

grammar

BIN(value)

The value here is a BIGINT number, which is the binary value to be retrieved.

Example

mysql> Select BIN(15);
+---------+
| BIN(15) |
+---------+
| 1111    |
+---------+
1 row in set (0.00 sec)

The above is the detailed content of In MySQL, how do we get the string representation of the binary value of a number?. For more information, please follow other related articles on the PHP Chinese website!