I want to add a column, what is wrong with this MySQL query?

Question

What is wrong with this query?

ALTER TABLE KARGO ADD COLUMN test VARCHAR(100) NOT NULL DEFAULT t

score 3 · Accepted Answer · answered Jul 11 '12 at 10:31

3

The DEFAULT t bit is wrong.

You need to quote the default value DEFAULT 't'

answered Jul 11 '12 at 10:31

Mihai Stancu

Sashi Kant · Answer 2 · 2012-07-11T10:38:35.117

0

The default value should be quoted as the field is varchar , Correct syntax :

ALTER TABLE KARGO ADD COLUMN testt VARCHAR (100) NOT NULL DEFAULT 't'

edited Jul 11 '12 at 10:38

answered Jul 11 '12 at 10:33

Sashi Kant

Or a float, or a hex, or a binary or a boolean or a null or a... heck most things are unquoted *except* strings. – Mihai Stancu Jul 11 '12 at 10:37

2 Answers2