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, 1861🔥, 0💬
Popular Posts:
How To Change the Name of a Database User in SQL Server? If you want to change the name of an existi...
How to download and install Microsoft SQL Server Management Studio Express in SQL Server? Microsoft ...
How To Use GO Command in "sqlcmd" in SQL Server? "sqlcmd" is a command line client application to ru...
How To Create a Stored Program Unit in Oracle? If you want to create a stored program unit, you can ...
How To Set Up SQL*Plus Output Format in Oracle? If you want to practice SQL statements with SQL*Plus...