CODEWITHSUNDEEP
mysqlsql
rpophessagr
rpophessagr

Reputation: 905

Create Column Allow NULL but Default Value Set to NOT NULL

Id like to create a column on my table that allows null but is set by default to empty (not null)

ALTER TABLE {TABLENAME} 
ADD {COLUMNNAME} {TYPE} DEFAULT '';

This doesn't seem to work. Any ideas?

Thanks!

Upvotes: 11

Views: 27221

Answers (2)

Neil
Neil

Reputation: 55392

If all else fails,

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

Upvotes: 0

Ted Hopp
Ted Hopp

Reputation: 234795

Did you try

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

Upvotes: 22

Related Questions