Deleting data

Write the query to delete a record with DELETE.

With DELETE we remove a record. WHERE picks which row to delete; without it all rows are deleted.

DELETE FROM notes
WHERE id = 3;

This deletes the note with id=3.

Rows are deleted from notes. Only the rows where id = 3 holds are affected.

Deleting data — details

Delete is the D in CRUD. After DELETE FROM comes the table name, then WHERE with a condition. Deleted data cannot be undone; be careful.

Delete the row with id=3 from the notes table.

Show example solution

DELETE FROM notes
WHERE id = 3

Delete row

DELETE ____ notes
WHERE id = 3;

Show answer

DELETE FROM notes
WHERE id = 3;