Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query
optimization, and usability that you won’t want to miss.
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).
BIN ( expression )
The function BINARY is not an alias for BIN.
A string containing numeric value, in binary. Float values are truncated. Returns NULL if expression is NULL.
SELECT BIN(1234);
+-------------+
| BIN(1234) |
+-------------+
| 10011010010 |
+-------------+
SELECT BIN(1234.5678);
+----------------+
| BIN(1234.5678) |
+----------------+
| 10011010010 |
+----------------+