How can we enter numerical values as a BINARY number in MySQL statement?

Following are the two approaches with the help of which we can enter numeric values as a BINARY number −

By prefix ‘B’

In this approach we need to quote binary numbers within single quotes with a prefix of B. Then BINARY number string will be automatically converted into a numerical value based on the expression context.

Example

mysql> Select B'1110'+0;
+-----------+
| B'1110'+0 |
+-----------+
|        14 |
+-----------+
1 row in set (0.00 sec)

By prefix 0b

In this approach, we need to write BINARY numbers without any quotes with a prefix of 0b. Then BINARY number string will be automatically converted into a numerical value based on the expression context.

Example

mysql> Select 0b1110+0;
+----------+
| 0b1110+0 |
+----------+
|       14 |
+----------+
1 row in set (0.00 sec)

Vanithasree

Published on 22-Feb-2018 07:48:56

• Related Questions & Answers
• How can we enter characters as a BINARY number in MySQL statement?
• How can we enter numeric values as Hexadecimal (HEX) number in MySQL statement?
• How can we enter characters as Hexadecimal (HEX) number in MySQL statement?
• How can we enter BOOLEAN values in MySQL statement?
• How can we specify default values in MySQL INSERT statement?
• Can we return query results in same order as the values in MySQL `IN(…)` statement?
• How can we update any value in MySQL view as we can update the values in MySQL table?
• How can we run a MySQL statement without termination semicolon?
• How can we use a MySQL subquery with INSERT statement?
• How can we update columns values on multiple rows with a single MySQL UPDATE statement?
• In MySQL, how we can write Multiple-line statement?
• How can we escape special characters in MySQL statement?
• How can we use MySQL SELECT statement to count number of rows in a table?
• How can we update values in a MySQL table?
• How can we count a number of unique values in a column in MySQL table?