DELETE FROM

Remove rows from a table

Mutation

SQL

DELETE FROM users WHERE id = 1;

What each clause does

DELETE FROM removes rows from the table. WHERE specifies which rows to delete—without it, all rows would be removed.

Related tools

SQL Formatter SQL Syntax Cheatsheet

Other SQL examples

SELECT All Rows SELECT with WHERE INSERT INTO UPDATE SET INNER JOIN LEFT JOIN GROUP BY ORDER BY Subquery CREATE TABLE Common Table Expression (CTE)Window Function UPSERT (ON CONFLICT)LIMIT & OFFSET