AnalyzeCode

Page Index

DBMS Introduction

MySQL Database

MySQL Tables

MySQL Queries

MySQL Clauses

MySQL Conditions

MySQL Keys

MySQL IS NULL

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: expression IS NULL

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

Let us consider table citizen with this data

select * from citizen where city IS NULL;

Let's move on to use of IS NOT NULL in MySQL

Previous

MySQL NOT EQUAL

Next :

MySQL IS NOT NULL

Share this page on :

© 2022 AnalyzeCode.com All rights reserved.