- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
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)
- Related Articles
- 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 BOOLEAN values in MySQL statement?
- How can we enter characters as Hexadecimal (HEX) number 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 update columns values on multiple rows with a single MySQL UPDATE statement?
- How can we use MySQL SELECT statement to count number of rows in a table?
- How can we count a number of unique values in a column in MySQL table?
- How can we update values in a MySQL table?
- In MySQL, how we can write Multiple-line statement?
- How can we escape special characters in MySQL statement?
- How can we use a MySQL subquery with INSERT statement?
- How can we run a MySQL statement without termination semicolon?

Advertisements