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, 1860🔥, 0💬
Popular Posts:
Where to find answers to frequently asked questions on PHP Connections and Query Execution for MySQL...
Where to find answers to frequently asked questions on Storage Engines: MyISAM, InnoDB and BDB in My...
What Is a Dynamic Performance View in Oracle? Oracle contains a set of underlying views that are mai...
What Is the Difference Between GETDATE() and GETUTCDATE() in SQL Server Transact-SQL? The difference...
Can You Drop an Index Associated with a Unique or Primary Key Constraint in Oracle? You can not dele...