Deleting Data from MySQL Tables

DELETE with WHERE

DELETE FROM employees WHERE id = 2;

Delete All Rows

DELETE FROM employees;

Use with caution — consider using TRUNCATE if you want to remove all rows quickly.