SQL default values

by

SQL default values

Today, when I was working with my teammate, I noticed, that they had some more information in the schema, than I am used to. I am used to the column names and type, but they also had the default values and whenever the column can be NULL or NOT NULL.

If I want to add new column with these values set, I could do it with the below SQL statment (based on not mine PR):

ALTER TABLE table ADD column type NOT NULL DEFAULT 'default value';

I could probably do something similar, when either changing the column or creating a table.

This was seen on the MySQL database.