DEFAULT

Give columns a default value.

With DEFAULT you set a fallback value used when no value is given for a column.

CREATE TABLE products (
  id INT PRIMARY KEY,
  stock INT DEFAULT 0
);

If stock is omitted it becomes 0.

The table products is created.

DEFAULT — details

With DEFAULT CURRENT_TIMESTAMP you can auto-fill the insert time. DEFAULT can be a constant, function or expression.

Create products with id INT PRIMARY KEY and stock INT DEFAULT 0.

Show example solution

CREATE TABLE products (
  id INT PRIMARY KEY,
  stock INT DEFAULT 0
)

Default

CREATE TABLE products (
  stock INT ____ 0
);

Show answer

CREATE TABLE products (
  stock INT DEFAULT 0
);

Next lesson: PRIMARY KEY