- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
What is the method with the help of which the hexadecimal value can be treated as a number?
For treating the hexadecimal value as a number, we can use the CAST(… AS UNSIGNED) function. Following example will demonstrate it −
mysql> Select 0x54, CAST(0x54 AS UNSIGNED); +------+------------------------+ | 0x54 | CAST(0x54 AS UNSIGNED) | +------+------------------------+ | T | 84 | +------+------------------------+ 1 row in set (0.01 sec)
Published on 21-Feb-2018 07:54:57
- Related Questions & Answers
- Which MySQL query can be used with the help of which we can see the list of MySQL databases?
- What is the synonym statement of SHOW DATABASES with the help of which we can see the list of MySQL databases?
- What is the default type of a hexadecimal value in MySQL?
- What is the use of the VALUE function in a DB2? Explain with the help of an example
- Can tonsils be treated at home?
- How can INTERSECTION between tables be implemented with the help of MySQL joins?
- How DIFFERENCES between tables can be implemented with the help of MySQL joins?
- What is the Value pricing method?
- Which is the best website for essay writing help?
- What is the purpose of COALESCE function? Explain with the help of an example.
- Which punctuation character can be used as the delimiter between MySQL date parts?
- Which punctuation character can be used as the delimiter between MySQL time parts?
- Can a method have the same name as the class?
- How can I add a new column which counts the number of rows as serial number in MySQL?
- Python Program to find out the number of rooms in which a prize can be hidden
Advertisements