Alter table add column and set default value in MySQL

Question

Is there a way to add a new column and set its default value in MySQL? When I run this command I get a syntax error:

ALTER TABLE tableName ADD newColumn varchar(20) SET DEFAULT 'test';

The documentation I've found doesn't really help me.

Possible duplicate of [Adding a new SQL column with a default value](http://stackoverflow.com/questions/3569347/adding-a-new-sql-column-with-a-default-value) — Godin, Nov 15 '16 at 23:57

score 7 · Answer 1 · answered Nov 16 '16 at 00:17

7

The SET shouldn't be necessary:

ALTER TABLE tableName ADD newColumn varchar(20) DEFAULT 'test';

answered Nov 16 '16 at 00:17

Gordon Linoff

score -1 · Answer 2 · answered Oct 27 '17 at 21:18

-1

try this

ALTER TABLE tableName ADD COLUMN newColumn VARCHAR(20) DEFAULT 'test';

answered Oct 27 '17 at 21:18

Martin Britez

2 Answers2