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, 1330🔥, 0💬
Popular Posts:
How To Use GO Command in "sqlcmd" in SQL Server? "sqlcmd" is a command line client application to ru...
Is PL/SQL Language Case Sensitive in Oracle? PL/SQL language is not case sensitive: Reserved words a...
How To Query Tables and Loop through the Returning Rows in MySQL? The best way to query tables and l...
How To Use GO Command in "sqlcmd" in SQL Server? "sqlcmd" is a command line client application to ru...
How To Verify a User name with SQLCMD Tool in SQL Server? The quickest way to verify a user name in ...