Query Quest PostgreSQL Course

Update data

UPDATE changes existing rows. SET specifies the new value; WHERE chooses which rows change. Without WHERE, every row is updated.

What you'll learn

You can calculate with existing values: xp = xp + 250.

Your mission

Give moss 250 more xp. Their new total should be 790.

Enable JavaScript to run SQL in the interactive lesson.