SQL: DELETE

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)