There are numerous cases in which you get null and are not able to handle it effectively in the code. has a command that can help you know if the value is null and then you can tell 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 (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.

Source link


Please enter your comment!
Please enter your name here