Question

Insert default into not null column if value is null in MySQL?

Answer 1

NULL is always the preferred way in SQL to indicate that a data value is unspecified or nonexistent for any reason. The SQL zero-length string (empty string) is specified by two single quote characters. The empty string ('') is not the same thing as NULL.