General MySQL Oracle SQL Server

Expressions with NULL Values in MySQL

Q

What Happens If NULL Values Are Involved in Expressions in MySQL?

✍: FYIcenter.com

A

If NULL values are used in expressions, the resulting values will be NULL values. In other words:

  • Arithmetic expressions with NULL values result NULL values.
  • Comparison expressions with NULL values result NULL values.
  • Logical expressions with NULL values result NULL values.

The tutorial exercise shows you some interesting examples:

SELECT NULL + NULL FROM DUAL;
   NULL
  
SELECT NULL + 7 FROM DUAL;
   NULL

SELECT NULL * 7 FROM DUAL;
   NULL

SELECT NULL = NULL FROM DUAL;
   NULL

SELECT 0 < NULL FROM DUAL;
   NULL

SELECT '' > NULL FROM DUAL;
   NULL

SELECT NULL AND TRUE FROM DUAL;
   NULL

SELECT NULL OR TRUE FROM DUAL;
   1
   -- This is contradicting against the rules!

 

⇒ Converting Numeric Values to Character Strings in MySQL

⇐ What Is NULL Value in MySQL

⇑ Introduction to SQL Basics in MySQL

⇑⇑ MySQL Database Tutorials

2018-03-28, 3129🔥, 0💬

General MySQL Oracle SQL Server