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, 1388🔥, 0💬
Popular Posts:
How To Recover a Dropped Index in Oracle? If you have the recycle bin feature turned on, dropped ind...
How To Fix the INSERT Command Denied Error in MySQL? The reason for getting the "1142: INSERT comman...
What are DDL (Data Definition Language) statements for tables in SQL Server? DDL (Data Definition La...
How To Query Tables and Loop through the Returning Rows in MySQL? The best way to query tables and l...
What Is Oracle in Oracle? Oracle is a company. Oracle is also a database server, which manages data ...