mysql use default value when using null code example
Example 1: mysql select default if null
IFNULL(MAX(EMAIL), "[email protected]") as email
Example 2: mysql default value
CREATE TABLE table_name(
column_name data_type,
Column_name data_type DEFAULT ‘value’
);