Removing from cart

Write the DELETE query to remove an item from the cart.

To remove a line from the cart you use DELETE. WHERE picks which row to delete.

DELETE FROM cart
WHERE id = 2;

This query removes line 2 from the cart.

Rows are deleted from cart. Only the rows where id = 2 holds are affected.

Removing from cart — details

Deletion cannot be undone. DELETE without WHERE empties the whole cart; always use WHERE.

Delete the line with id=2 from cart.

Show example solution

DELETE FROM cart
WHERE id = 2

Delete row

DELETE ____ cart
WHERE id = 2;

Show answer

DELETE FROM cart
WHERE id = 2;

Next lesson: ROUND