Snatch any course you want for just $15! Go to “Courses” and find a course ↓
Introduction
Default values
7. INSERT using DEFAULT for all columns
Summary

Instruction

Amazing! What about using DEFAULT for all columns? You can use a statement like this:

INSERT INTO all_defaults_table VALUES (DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT);

SQL again allows you to use a shorter query:

INSERT INTO all_defaults_table DEFAULT VALUES;

Using DEFAULT for every table column is a very rare case, so we don't need to discuss it in detail. Just remember that you can use this syntax if needed.

Exercise

Click Next exercise to continue.