Create Column Allow NULL but Default Value Set to NOT NULL

mysql sql

Did you try

ALTER TABLE table_name ADD column_name VARCHAR(20) NULL DEFAULT '';

mysql sql

If all else fails,

CREATE TRIGGER trigger_tablename_columnname  BEFORE INSERT ON tablename  FOR EACH ROW SET NEW.columnname = IFNULL(NEW.columnname, '')

CodeHunter