DEFAULT values

Use the DEFAULT keyword in INSERT.

If you skip a column or write DEFAULT, the table's default value is used.

INSERT INTO products (id, name)
VALUES (6, 'Mouse');

Stock and category columns take their defaults.

The values given with VALUES are inserted into products as new rows.

DEFAULT values — details

The table definition gives DEFAULT 0 or DEFAULT CURRENT_TIMESTAMP. A skipped column takes NULL or its default.

Insert id=6, name='Mouse' into products; let other columns take defaults.

Show example solution

INSERT INTO products (id, name)
VALUES (6, 'Mouse')

Default

INSERT INTO products (id, name)
VALUES (6, 'Mouse', ____);

Show answer

INSERT INTO products (id, name)
VALUES (6, 'Mouse', DEFAULT);