MySQL SQL - How To Calculate Expressions with SQL Statements

How To Calculate Expressions with SQL Statements

Q

How To Calculate Expressions with SQL Statements? - MySQL FAQs - Introduction to SQL Basics

✍: 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

2016-11-09, 6241👍, 1💬

💬 2016-11-09 lux: good

How To Include Character Strings in SQL statements
How To Include Character Strings in SQL statements? - MySQL FAQs - Introduction to SQL Basics If you want to include character strings in your SQL statements, you need to quote them in one of the following formats: Using single quotes. For example 'FYIcenter.com'. Using double quotes. For example "F... 2007-05-11, 4369👍, 0💬

How To Include Comments in SQL Statements
How To Include Comments in SQL Statements? - MySQL FAQs - Introduction to SQL Basics If you want to include comments in a SQL statement, you can first enter "--", then enter your comment until the end of the line. The tutorial exercise below shows you some good examples: SELECT 'Hello world!' FROM D... 2007-05-11, 4204👍, 0💬

What Are Date and Time Data Types
What Are Date and Time Data Types? - MySQL FAQs - Introduction to SQL Basics MySQL supports the following date and time data types: DATE - A date in the range of '1000-01-01' and '9999-12-31'. Default DATE format is "YYYY-MM-DD". DATETIME - A date with the time of day in the range of '1000-01-01 00:... 2007-05-11, 4164👍, 0💬

What Are Numeric Data Types
What Are Numeric Data Types? - MySQL FAQs - Introduction to SQL Basics MySQL supports the following numeric data types: BIT(n) - An integer with n bits. BOOL same as BOOLEAN - Boolean values stored in 1 bit. TINYINT - A small integer stored in 1 byte. SMALLINT - A small integer stored in 2 bytes. ME... 2007-05-11, 4145👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.