RivoCode

SQL Fundamentals · Updating & Deleting · Lesson 10 of 17

Updating Rows

Concept

Updating Rows

UPDATE changes existing data in a table. Always pair it with a WHERE clause, or every row in the table will be updated.

By the end of this lesson
  • Explain the core idea behind Updating 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
UPDATE students
SET age = 21
WHERE id = 1;
Try it Yourself »
Self-check before continuing

Without looking at the example, describe what changes when you modify one input in Updating 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 UPDATE statement that changes one student's name.

Loading editor…

Console

Output will appear here...