SQL Snippets

This is a place to dump random snippets of SQL

Deleting from a Table

-- delete rows where col1 is 'whatever'
DELETE FROM table_name
WHERE col1 = "whatever"