Sql - DELETE
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...
↶
↷
Seven Codémons left. And without WHERE:
↗️
Loading editor...
↶
↷
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