RSS Feed
Download our iPhone app
Browse DevX
Sign up for e-mail newsletters from DevX

By submitting your information, you agree that devx.com may send you DevX offers via email, phone and text message, as well as email offers about other products and services that DevX believes may be of interest to you. DevX will process your information in accordance with the Quinstreet Privacy Policy.


Tip: Using IFNULL in MySQL

Check out this MySQL command to handle null effectively in your code.




Building the Right Environment to Support AI, Machine Learning and Deep Learning

There are numerous cases in which you get null and are not able to handle it effectively in the code. MySQL has a command that can help you know if the value is null and then you can tell MySQL to return an appropriate value, so that you can process accordingly in the code. This resolves ambiguities at times, and you will be able to write effective code.

SELECT IFNULL(column_name,'returnValue') FROM `database_name`.`table_name`;

Here, there column_name is the column on which the null check is imposed and the returnValue is the data that you want MySQL to return in the case that this column is null. Enjoy this mechanism to handle null effectively in your code.


Visit the DevX Tip Bank


Sridhar M S. is a Java developer from Bangalore, India. He holds a master's degree in Computer Science.
Comment and Contribute






(Maximum characters: 1200). You have 1200 characters left.



Thanks for your registration, follow us on our social networks to keep up-to-date