The DELTE command allows you to drop records, permanently, from a table. There’s no "undo" for this operation, so make sure you have adequate back-ups in case something goes wrong. A good safety measure is to use a SELECT statement first to see what records will be deleted.
For example, using the Holiday table, if we are no longer interested in holidays from the 1980s, we could check which records fell into this category by using:
SELECT * FROM Holiday WHERE StartDate < "1/1/90";
Then delete them with:
DELETE * FROM Holiday WHERE StartDate < "1/1/90";
To drop all the records from a table:
DELETE * FROM Holiday;
Please use with care!
See also: