Records

select

select column-list
    from table-list
    [ where search-condition ]
    [ group by grouping-column ]
    [ having search-condition ]
    [ order by ordering-condition ];

search-condition:
    [ ... between ... ]
    [ ... [not] in ... ]
    [ ... [not] like ... ]
    [ ...  null ... ]
    [ ... [all, some, any] ... ]
    [ ... [not] exists ... ]
    [ ... unique ... ]
    [ ... overlaps ... ]
    [ ... match ... ]

    [ ... and ... ]
    [ ... or ... ]
    [ ... not ... ]

insert

-- Add a single row
insert into table-name [(explicit-column-list)]
    values (value-list);

-- Transfer rows from one table to another
insert into table-name [(explicit-column-list)]
    select-statement;

• The default column-list order is the order of the columns in the table
• Columns omitted from the column-list will have null values

update

update table-name
    set column1 = expr1, column2 = expr2, ...
    [where-clause];

delete

-- Delete the specified rows
delete from table-name
    where-clause;

-- Delete all rows
delete from table-name;

-- Delete all rows (not always supported)
truncate table table-name;