default a column with empty string

Question

Is there a way, via a SQL statement, to ensure a column's default value is an empty string '' instead of NULL?

OMG Ponies · Accepted Answer · 2010-07-28 22:10:27Z

74

Yes - use a DEFAULT constraint:

DROP TABLE IF EXISTS `example`.`test`;
CREATE TABLE  `example`.`test` (
  `string_test` varchar(45) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

answered Jul 28, 2010 at 22:10

OMG Ponies

334k85 gold badges536 silver badges508 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

user114600 Over a year ago

Could you use SPACE(0) in a VARCHAR or NVARCHAR column?

OMG Ponies Over a year ago

@Randolph Potter: SPACE() is a TSQL/SQL Server function - so "No" for MySQL.

Collectives™ on Stack Overflow

default a column with empty string

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related