SELECT
, FROM
, ORDER BY
, LIMIT
, OFFSET
. Conditions can be added using WHERE
with opeartors, GROUP BY
, aggregate function. Multi-table querying can be completed using JOIN
.CREATE TABLE IF NOT EXISTS mytable
and DROP TABLE IF EXISTS mytable
ALTER TABLE mytable
, where commands like ADD column, dataTyle, Optional constraint, DEFAULT
can be added; same thing applies to remove columns, using DROP
https://cdn2.hubspot.net/hubfs/392937/Learn%20SQL.pdf ↩