RivoCode

SQL Fundamentals · Inserting & Querying Data · Lesson 4 of 17

Inserting Rows

Concept

Inserting Rows

INSERT INTO adds a new row to a table, specifying which columns you are filling in and their values.

By the end of this lesson
  • Explain the core idea behind Inserting Rows.
  • Predict output before running a change.
  • Test one realistic and one unusual input.
  • Use the result to make the next decision.
How to study this page
  1. 1. Read one concept.
  2. 2. Change the example.
  3. 3. Run, compare, and explain.
  4. 4. Complete the challenge below.
ExampleRunnable
INSERT INTO students (id, name, age)
VALUES (1, 'Alex', 20);
Try it Yourself »
Self-check before continuing

Without looking at the example, describe what changes when you modify one input in Inserting Rows. Then reopen the editor and prove your explanation with a small test.

You are ready to continue when you can predict, test, and explain the result.

Your turn

Write an INSERT statement that adds a second student to the table.

Loading editor…

Console

Output will appear here...