Delete
Example: Delete a record in the Employee table
DELETE FROM Employee
WHERE EmployeeID = 419031;
Output:
Query OK, 1 row affected (0.01 sec)Example: Delete ALL records in the Employee table
DELETE FROM Employee;
Output:
Query OK, 2,330 row affected (0.01 sec)