Deleting rows from a table
•
DELETE FROM sources
WHERE name like 'NGC70__';
•
•
DELETE FROM sources
WHERE name like 'NGC70%';
•
•
TRUNCATE TABLE sources;
efficiently deletes ALL rows
_ is the wildcard for a single character
% is the wildcard for zero or more characters