Updating data

Write the query to update a record with UPDATE.

With UPDATE we change an existing record. SET gives the new value, WHERE picks which row to update.

UPDATE notes
SET title = 'Market listesi'
WHERE id = 3;

This updates the title of the note with id=3.

In notes, title = 'Market listesi' is updated. Only the rows where id = 3 holds are affected.

Updating data — details

Update is the U in CRUD. Without WHERE, UPDATE changes every row; always include a condition.

Set the title of the row with id=3 in notes to 'Shopping list'.

Show example solution

UPDATE notes
SET title = 'Market listesi'
WHERE id = 3

New value

UPDATE notes
____ title = 'Yeni'
WHERE id = 3;

Show answer

UPDATE notes
SET title = 'Yeni'
WHERE id = 3;