AnalyzeCode

Page Index

DBMS Introduction

MySQL Database

MySQL Tables

MySQL Queries

MySQL Clauses

MySQL Conditions

MySQL Keys

MySQL IS NOT NULL

MySQL IS NOT NULL condition is used to check the NOT NULL value in the expression. It is used with SELECT, INSERT, UPDATE and DELETE statements.

Syntax: expression IS NOT NULL

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

Let us consider table citizen with this data

select * from citizen where city IS NOT NULL;

Let's move on to use of BETWEEN in MySQL

Previous

MySQL IS NULL

Next :

MySQL BETWEEN

Share this page on :

© 2022 AnalyzeCode.com All rights reserved.