General MySQL Oracle SQL Server

Evaluating Expressions with SELECT Statements in MySQL

Q

How To Calculate Expressions with SELECT Statements in MySQL?

✍: FYIcenter.com

A

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

⇑ Introduction to SQL Basics in MySQL

⇑⇑ MySQL Database Tutorials

2018-04-12, 3105🔥, 0💬

General MySQL Oracle SQL Server