sql how set default value boolean of a new column?

Question

I need to set the default value of a new column from an already existed table to boolean False.

In my case, it should be like this :

id    car      boolean

1     Peugeot  false
2     Ford     false
3     Ferrari  false
...

I've tried this :

ALTER TABLE Vehicules
ADD operate boolean

Andronicus · Accepted Answer · 2019-03-10 10:17:29Z

3

You're missing a default <value> clause:

ALTER TABLE Vehicules
ADD operate boolean default true

answered Mar 10, 2019 at 10:17

Andronicus

26.2k18 gold badges55 silver badges92 bronze badges

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

1 Answer 1