Collections:
Entering Numeric Values in MySQL
How To Include Numeric Values in SQL statements in MySQL?
✍: FYIcenter.com
If you want to include a numeric value in your SQL statement, you can enter it directly as shown in the following examples:
SELECT 255 FROM DUAL; -- An integer 255 SELECT -6.34 FROM DUAL; -- A regular number -6.34 SELECT -32032.6809e+10 FROM DUAL; -- A floating-point value -3.20326809e+014
⇒ Entering Characters as HEX Numbers in MySQL
⇐ Concatenating Character Strings in MySQL
2018-03-31, 1455🔥, 0💬
Popular Posts:
How REAL and FLOAT Literal Values Are Rounded in SQL Server Transact-SQL? By definition, FLOAT(n) sh...
What Happens If the UPDATE Subquery Returns Multiple Rows in SQL Server? If a subquery is used in a ...
What Is the Difference Between GETDATE() and GETUTCDATE() in SQL Server Transact-SQL? The difference...
How To Get a List of All Tables with "sys.tables" View in SQL Server? If you want to see the table y...
Where to find answers to frequently asked questions on Transaction Management: Commit or Rollback in...