Sql - DELETE
📖 Read the lesson
Code Life
By Pierre Marsaa
Removing rows
DELETE FROM
removes rows. There is no column list — a row goes entirely — and the
WHERE
chooses which ones:
↗️
Loading editor...
↶
▶️ Run
↷
Seven Codémons left. And without
WHERE
:
↗️
Loading editor...
↶
▶️ Run
↷
Empty, but still there
DELETE
without
WHERE
removes
every row
, but the table itself survives: its columns are intact and you can insert again.
Verify