MySQL IFNULL Function: Equivalent to Oracle ISNULL
In MySQL, the equivalent function to Oracle's ISNULL is IFNULL. Here is an example:
SELECT IFNULL(column_name, 'default_value') FROM table_name;
This query will return the value of column_name if it is not null, and 'default_value' if it is null.
原文地址: https://www.cveoy.top/t/topic/nh6f 著作权归作者所有。请勿转载和采集!