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)