sql - evanmoran/quick GitHub Wiki

Creating a Table

CREATE TABLE table_name
(
column_name1 data_type,
column_name2 data_type,
...
)

Inserting

INSERT INTO table_name
VALUES (value1, value2, value3,....)

INSERT INTO table_name
(column1, column2, column3,...)
VALUES (value1, value2, value3,....)

Querying

SELECT column_name(s)
FROM table_name
WHERE column_name operator value

SELECT column_name(s)
FROM table_name
WHERE column_name
BETWEEN value1 AND value2

SELECT column_name(s)
FROM table_name
WHERE condition
AND|OR condition

Indexing

CREATE INDEX index_name
ON table_name (column_name)

CREATE UNIQUE INDEX index_name
ON table_name (column_name)

Joining

SELECT column_name(s)
FROM table_name1
INNER JOIN table_name2 
ON table_name1.column_name=table_name2.column_name

Note: INNER may be replaced with LEFT, RIGHT, or FULL