Javatpoint Logo
Javatpoint Logo

MySQL IS NULL Condition

MySQL IS NULL condition is used to check if there is a NULL value in the expression. It is used with SELECT, INSERT, UPDATE and DELETE statement.

Syntax:

Parameter

expression: It specifies a value to test if it is NULL value.

Consider a table "officers" having the following data.

MySQL IS NULL Condition 1

Execute the following query:

Output:

MySQL IS NULL Condition 2

Note: Here, you are getting the empty result because there is no NULL value in officer_name column.

Next TopicMySQL IS NOT NULL




Youtube For Videos Join Our Youtube Channel: Join Now

Feedback

Help Others, Please Share

facebook twitter pinterest

Learn Latest Tutorials

digital marketing tutorial

Digital Marketing
elasticsearch tutorial

Elasticsearch
entity framework tutorial

Entity Framework
Firewall tutorial

Firewall
Functional Programming tutorial

Functional Programming
Google Colab tutorial

Google Colab
Graph Theory tutorial

Graph Theory
Groovy tutorial

Groovy
Group Discussion tutorial

Group Discussion
Informatica tutorial

Informatica
Ionic tutorial

Ionic
ITIL tutorial

ITIL
IOS Development tutorial

IOS with Swift
angular material tutorial

Angular Material
deep learning tutorial

Deep Learning

Preparation

Aptitude

Aptitude
Logical Reasoning

Reasoning
Verbal Ability

Verbal Ability
Interview Questions

Interview Questions
Company Interview Questions

Company Questions

Trending Technologies

Artificial Intelligence Tutorial

Artificial Intelligence
AWS Tutorial

AWS
Selenium tutorial

Selenium
Cloud Computing tutorial

Cloud Computing
Hadoop tutorial

Hadoop
ReactJS Tutorial

ReactJS
Data Science Tutorial

Data Science
Angular 7 Tutorial

Angular 7
Blockchain Tutorial

Blockchain
Git Tutorial

Git
Machine Learning Tutorial

Machine Learning
DevOps Tutorial

DevOps

B.Tech / MCA

DBMS tutorial

DBMS
Data Structures tutorial

Data Structures
DAA tutorial

DAA
Operating System tutorial

Operating System
Computer Network tutorial

Computer Network
Compiler Design tutorial

Compiler Design
Computer Organization and Architecture

Computer Organization
Discrete Mathematics Tutorial

Discrete Mathematics
Ethical Hacking Tutorial

Ethical Hacking
Computer Graphics Tutorial

Computer Graphics
Software Engineering Tutorial

Software Engineering
html tutorial

Web Technology
Cyber Security tutorial

Cyber Security
Automata Tutorial

Automata
C Language tutorial

C Programming
C++ tutorial

C++
Java tutorial

Java
.Net Framework tutorial

.Net
Python tutorial

Python
List of Programs

Programs
Control Systems tutorial

Control System
Data Mining Tutorial

Data Mining
Data Warehouse Tutorial

Data Warehouse