Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

How to INSERT, UPDATE, and DELETE Data in SQL

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.