Unsupported versions: 6.3
Prev Chapter 4. The Query Language Next


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.
Prev Home Next
Updates Up Using Aggregate Functions