sql

SQL Statements Supported by Alasql

• 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