Deletions are performed using the delete command:
DELETE FROM weather WHERE city = 'Hayward';
All weather recording belongs to Hayward is removed.
One should be wary of queries of the form
DELETE FROM classname;
Without a qualification, delete will simply
remove all instances of the given class, leaving it
empty. The system will not request confirmation before
doing this.