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, 1987🔥, 0💬
Popular Posts:
What To Do If the StartDB.bat Failed to Start the XE Instance in Oracle? If StartDB.bat failed to st...
How to download and install Microsoft SQL Server Management Studio Express in SQL Server? Microsoft ...
Is SQL Server Transact-SQL case sensitive? No. Transact-SQL is not case sensitive. Like the standard...
What Is SQL*Plus in Oracle? SQL*Plus is an interactive and batch query tool that is installed with e...
Where to find answers to frequently asked questions on Transaction Management: Commit or Rollback in...