Collections:
Evaluating Expressions with SELECT Statements in MySQL
How To Calculate Expressions with SELECT Statements in MySQL?
✍: FYIcenter.com
There is no special SQL statements to calculate expressions. But you can use the "SELECT expression FROM DUAL" statement return the calculated value of an expression. "DUAL" is a dummy table in the server. The tutorial exercise below shows you some good examples:
SELECT 'Hello world!' FROM DUAL; Hello world! SELECT (1+2)*3/4 FROM DUAL; 2.2500 SELECT TRUE FROM DUAL; 1 SELECT TRUE AND FALSE FROM DUAL; 0 SELECT TIME(SYSDATE()) FROM DUAL; 21:30:26
⇒ Including Comments in SQL Statements in MySQL
⇐ Date and Time Data Types in MySQL
2018-04-12, 1471🔥, 0💬
Popular Posts:
How To Format Time Zone in +/-hh:mm Format in SQL Server Transact-SQL? From the previous tutorial, y...
How To Round a Numeric Value To a Specific Precision in SQL Server Transact-SQL? Sometimes you need ...
How To Use SQL*Plus Built-in Timers in Oracle? If you don't have a stopwatch/timer and want to measu...
How To Use DATEADD() Function in SQL Server Transact-SQL? DATEADD() is a very useful function for ma...
How To Convert Numeric Expression Data Types using the CONVERT() Function in SQL Server Transact-SQL...