How can we enter numeric values as Hexadecimal (HEX) number in MySQL statement?


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

By prefix ‘X’

In this approach we need to quote hexadecimal numbers within single quotes with a prefix of X. Then HEX number string will be automatically converted into a number based on the expression context.

Example

mysql> Select X'5152545678'+ 10;
+-------------------+
| X'5152545678'+ 10 |
+-------------------+
| 349273609858      |
+-------------------+
1 row in set (0.00 sec)

By prefix 0x

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

Example

mysql> Select 0x5152545678+10;
+-----------------+
| 0x5152545678+10 |
+-----------------+
| 349273609858    |
+-----------------+
1 row in set (0.00 sec)

Updated on: 22-Jun-2020

107 Views

Kickstart Your Career

Get certified by completing the course

Get Started
Advertisements