ASSERT

ALTER TABLE

ALTER TABLE ADD COLUMN

ALTER TABLE MODIFY COLUMN

ALTER TABLE DROP COLUMN

ALTER TABLE RENAME TABLE

BEGIN TRANSACTION

BACKUP DATABASE

COMMIT TRANSACTION

CREATE

CREATE DATABASE

CREATE INDEX

CREATE TABLE

Column Types

• JavaScript data types
  • String
  • Number
  • Boolean
  • Date and ISODate
• ANSI SQL types
• SQLite, Oracle, MySQL, SQL Server, Postgress data types mapping

Column constraints

• PRIMARY KEY
• FOREIGN KEY
• DEFAULT
• NULL / NOT NULL
• AUTO_INCREMENT, IDENTITY
• CHECK

Constraints

• PRIMARY KEY
• FOREIGN KEY

CREATE TRIGGER

CREATE VIEW

DELETE

DROP

DROP DATABASE

DROP INDEX

DROP TABLE

DROP TRIGGER

DROP VIEW

INSERT

INSERT SELECT

INSERT VALUES

INSERT DEFAULT VALUES

RENAME TABLE (see also ALTER TABLE RENAME TABLE)

RESTORE DATABASE

ROLLBACK TRANSACTION

SELECT

TOP

DISTINCT

INTO

FROM

JOIN

GROUP BY

HAVING

ORDER BY

LIMIT

OFFSET

UNION

UNION ALL

INTERSECT

EXCEPT

SHOW

SHOW CREAET TABLE

SHOW COLUMNS

SHOW DATABASES

SHOW INDEX

SHOW TABLES

UPDATE

USE DATABASE

Operators

Number

• • • / %

String

Comparing

= != < <= > >=

BETWEEN, NOT BETWEEN

Null

• IS NULL, IS NOT NULL

SQL-Functions

ABS()

Complex Operators

• EXISTS, NOT EXISTS
• IN, NOT IN
• SOME, ANY
• ALL

Aggregators

SUM()

COUNT()

AVG()

MIN()

MAX()

FIRST()

LAST()

Groupping functions

CUBE()

ROLLUP()

GROUPING SETS()

Standard functions

User-defined SQL functions