DELETE
command
Removes rows from a table. Always include WHERE unless you intend to delete all rows.
Syntax
DELETE FROM table WHERE condition;
Example
sql
-- Delete single row
DELETE FROM users WHERE id = 5;
-- Delete with condition
DELETE FROM sessions WHERE expires_at < NOW();
-- Delete all rows (use TRUNCATE for speed)
DELETE FROM temp_data;
TRUNCATE TABLE temp_data; -- faster, resets AUTO_INCREMENT