Inserting Data with INSERT

INSERT adds new rows to a table. This is how data gets into the database.

Basic INSERT Syntax

INSERT INTO table_name (column1, column2, ...)
VALUES (value1, value2, ...);

Exercises

The playground has a "Reset DB" button to restore the original data after you make changes.

INSERT with Products

Let's work with the products table:

Common Mistakes

1. Mismatched columns and values - must be same count, same order
2. Forgetting quotes for text values
3. Wrong data type - text where number expected

Free Practice

Try:

• Insert multiple users
• Insert a user with NULL age (omit the column)
• Insert and then query to verify