CodesJava

Easy learning with example program codes

IS NULL in MySQL

MySQL IS NULL
To filter the results, the MySQL IS NULL condition is used with SELECT, INSERT, UPDATE and DELETE statements to check for a NULL value.

Syntax:

WHERE expression IS NULL; 

Parameters:
expression: It is used to specify a column or a field to be tested.

Example:
Students table:

ID	NAME	AGE
1	Joy	5
2	Smiley	13
3	Happy	11
4	Tom	15
5	Jerry	10
6	Bruno	
7	David	

Query:

SELECT name
FROM students  
WHERE  age IS NULL;

Output:

NAME
Bruno
David
2 rows  in set <0.00 sec>
Please follow and like us:
error









Copyright © 2019 CodesJava DMCA.com Protection Status