Deleting Records

The delete statement is used to delete records or rows from the table.

delete from "tablename"

where "columnname"
OPERATOR "value"
[and|or "column"
OPERATOR "value"];

Examples:

delete from employee;

Note: if you leave off the where clause, all records will be deleted!

delete from employee where lastname = 'May'; delete from employee where firstname = 'Mike' or firstname = 'Eric';

To delete an entire record/row from a table, enter "delete from" followed by the table name, followed by the where clause which contains the conditions to delete. If you leave off the where clause, all records will be deleted.

Delete statement exercises

(Use the select statement to verify your deletes):

1. Jonie Weber-Williams just quit, remove her record from the table.
2. It's time for budget cuts. Remove all employees who are making over 70000 dollars.

Create at least two of your own delete statements, and then issue a command to delete all records from the table.

1. Jonie Weber-Williams just quit, remove her record from the table:

   delete
   from myemployees_ts0211
   where lastname =
     'Weber-Williams';

2. It's time for budget cuts. Remove all employees who are making over 70000 dollars.

   delete
   from myemployees_ts0211
   where salary >
     70000;[]