Given a TABLE, in this TABLE, it prints entry of the table. If table is empty then it gives NULL.
QUESTION : Given an employee table, print name from the given table which id equals to 2.
Output : Geek2
QUESTION : 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.
SELECT IFNULL( (SELECT NAME from employee where id = 2), 'NULL') as NAME;
SELECT IFNULL( (SELECT NAME from employee where id = 5), 'NULL') as NAME;
- MySQL | Common MySQL Queries
- MySQL | MD5 Function
- MySQL | BIN() Function
- MongoDB vs MySQL
- PHP | MySQL WHERE Clause
- MySQL | IF( ) Function
- How to get ID of the last updated row in MySQL?
- MySQL | COALESCE( ) Function
- Mathematical functions in MySQL
- MySQL | Ranking Functions
- MySQL | DEFAULT() Function
- MySQL | CONV( ) Function
- MySQL | BINARY Function
- MySQL | CONVERT( ) Function
- MySQL | Database Files
If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to firstname.lastname@example.org. See your article appearing on the GeeksforGeeks main page and help other Geeks.
Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.