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, 1461🔥, 0💬
Popular Posts:
What is dba.FYIcenter.com Website about? dba.FYIcenter.com is a Website for DBAs (database administr...
What Happens to Your Transactions When ERROR 1213 Occurred in MySQL? If your transaction receives th...
How to execute statements under given conditions in SQL Server Transact-SQL? How to use IF ... ELSE ...
How To Convert Characters to Numbers in Oracle? You can convert characters to numbers by using the T...
How To Generate CREATE VIEW Script on an Existing View in SQL Server? If you want to know how an exi...