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