The DELETE statement can be used to remove rows from a table.
In this example we remove the 2000 games from the table:

DELETE FROM games WHERE yr=2000; SELECT * FROM games;
DROP TABLE games CREATE TABLE games(yr INT, city VARCHAR(20)); INSERT INTO games(city,yr) VALUES ('Sydney',2000); INSERT INTO games(city,yr) VALUES ('Athens',2004); INSERT INTO games(city,yr) VALUES ('Beijing',2008); INSERT INTO games(city,yr) VALUES ('London',2012);

DELETE FROM games WHERE yr=2000;
SELECT * FROM games;