How to add default to an existing column in MariaDB?

Question

I have this simple table:

create table Customers
(
    Id bigint not null primary key auto_increment,
    Name varchar(100) not null,
    IsVip boolean null
)

Now I want to set a default value for IsVip column. I tried:

alter table Customers
modify IsVip set default 0

But it doesn't work. How should I do it?

Progman · Accepted Answer · 2021-12-28 16:56:01Z

3

According to the ALTER TABLE syntax you use the syntax

    | ALTER [COLUMN] col_name SET DEFAULT literal | (expression)

or the syntax

    | MODIFY [COLUMN] [IF EXISTS] col_name column_definition

In your case it can be

alter table Customers ALTER COLUMN IsVip set default 0

answered Dec 28, 2021 at 16:56

Progman

20.1k7 gold badges58 silver badges88 bronze badges

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

1 Comment

Yes, I was using modify incorrectly. Thank you so much.