SQLUPDATEDMLtutorial

What is UPDATE in SQL? Modifying rows for beginners

UPDATE is the SQL command for "change data in existing rows". Plain words: what to change, why WHERE is non-negotiable, how to update several columns at once. Before/after tables, beginner pitfalls, a quick recap, and three practice tasks at the end.

1 min readReferenceSQL · UPDATE · DML · tutorial

UPDATE is the command for changing data in rows that already exist. Not inserting new ones, not deleting — modifying what's there.

This article is currently in Russian. The full English translation is on the way.

PreviousWhat is INSERT in SQL? Adding rows for beginnersNextWhat is DELETE in SQL? Removing rows for beginners

Related articles

UPSERT in PostgreSQL: INSERT ... ON CONFLICT in PracticeMERGE in PostgreSQL 15+: MATCHED / NOT MATCHED, Upserts, and Table SyncINSERT ... ON CONFLICT DO NOTHING in PostgreSQL: Idempotent Inserts Without ErrorsRETURNING in PostgreSQL: Get IDs and Changed Rows Without a Second Round-Trip

Tasks on this topic

Discount on Action gamesDelete departures from MoscowSwap SalaryAdd a test userSeed a batch of test ordersPurge stale audit log rows

Practice on real tasks

Solve tasks in the SQL trainer with instant grading and hints.

Open trainer