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)

radhakrishna

Updated on: 2020-06-22T12:23:10+05:30

222 Views

Kickstart Your Career

Get certified by completing the course

Get Started