Collections:
Entering Numeric Values as HEX Numbers in MySQL
How To Enter Numeric Values as HEX Numbers in MySQL?
✍: FYIcenter.com
If you want to enter numeric values as HEX numbers, you can quote HEX numbers with single quotes and a prefix of (X), or just prefix HEX numbers with (0x). A HEX number string will be automatically converted into a numeric value, if the expression context is a numeric value. Here are some good examples:
SELECT X'10' + 16 FROM DUAL; 32 SELECT 0x1000 + 0 FROM DUAL; 4096
⇒ Entering Binary Numbers in MySQL
⇐ Entering Characters as HEX Numbers in MySQL
2018-03-31, 1413🔥, 0💬
Popular Posts:
Where to find answers to frequently asked questions on Downloading and Installing SQL Server 2005 Ex...
How To Round a Numeric Value To a Specific Precision in SQL Server Transact-SQL? Sometimes you need ...
How Fixed Length Strings Are Truncated and Padded in SQL Server Transact-SQL? When the length of the...
How To Convert Numeric Expression Data Types using the CAST() Function in SQL Server Transact-SQL? I...
How to download and install the scaled-down database AdventureWorksLT in SQL Server? If you want to ...