IFNULL in MySQL
Given a TABLE, in this TABLE, it prints entry of the table. If table is empty then it gives NULL.
Examples:
QUESTION : Given an employee table, print name from the given table which id equals to 2.
Output : Geek2QUESTION : Given same Employee table, print name from the given table which id equals to 5.
Output : NULL
Approach: In this case, we use here IFNULL. IFNULL print the null if the table is an empty or other condition.
Query:-
SELECT IFNULL( (SELECT NAME from employee where id = 2), 'NULL') as NAME;
Output:- Geek2
Query:-
SELECT IFNULL( (SELECT NAME from employee where id = 5), 'NULL') as NAME;
Output:- NULL
Attention reader! Don’t stop learning now. Get hold of all the important DSA concepts with the DSA Self Paced Course at a student-friendly price and become industry ready.