sql

Alasql SQL Statements

• [Single and multiple SQL statements](Multiple Statements)
• [Standard](Standard Interface) and [fluent (like LINQ)](Fluent Interface) interface
• [Case-sensitive keywords](Case Sensitive)

Short list by category

Data query

• SELECT

Data manipulation

• INSERT
• UPDATE
• DELETE

Data definition

• [CREATE TABLE](Create Table)
• [ALTER TABLE](Alter Table)
• [DROP TABLE](Drop Table)

Database

• [USE DATABASE](Use Database)
• [CREATE DATABASE](Create Database)
• [DROP DATABASE](Drop Database)

External database

• [ATTACH DATABASE](Attach Database)
• [DETACH DATABASE](Detach Database)

Transactions

• [BEGIN TRANSACTION](Begin Transaction)
• [COMMIT TRANSACTION](Commit Transaction)
• ROLLBACK TRANSACTION

Show

• [SHOW DATABASES](Show Databases)
• [SHOW TABLES](Show Tables)
• [SHOW CREATE TABLE](Show Create Table)

Program

• DECLARE
• SET
• IF THEN ELSE
• BEGIN END
• WHILE
• SOURCE

Debug

• ASSERT

Information

• HELP

Full list

• ASSERT

• ATTACH

• ALTER TABLE

• [ALTER TABLE ADD COLUMN](Add Column)

• [ALTER TABLE MODIFY COLUMN](Modify Column)

• [ALTER TABLE DROP COLUMN](Drop Column)

• [ALTER TABLE RENAME TABLE](Rename Table)

• [BEGIN TRANSACTION](Begin Transaction)

• [COMMIT TRANSACTION](Commit Transaction)

• CREATE

• [CREATE DATABASE](Create Database)

• [CREATE TABLE](Create Table)

• Column Types

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

• Column constraints

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

• DELETE

• DROP

• [DROP DATABASE](Drop Database)

• [DROP TABLE](Drop Table)

• INSERT

• [INSERT SELECT](Insert Select)

• [INSERT VALUES](Insert Values)

• [INSERT DEFAULT VALUES](Insert Default Values)

• [RENAME TABLE](Rename Table)

• [ROLLBACK TRANSACTION](Rollback Transaction)

• SELECT

• TOP

• DISTINCT

• INTO

• FROM

• JOIN

• [GROUP BY](Group By)

• HAVING

• [ORDER BY](Order By)

• LIMIT

• OFFSET

• UNION

• [UNION ALL](Union All)

• INTERSECT

• Minus,EXCEPT

• SHOW

• [SHOW CREATE TABLE](Show Create Table)

• [SHOW COLUMNS](Show Columns)

• [SHOW DATABASES](Show Databases)

• [SHOW TABLES](Show Tables)

• UPDATE

• [USE DATABASE](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()

• MIN()

• MAX()

• [FIRST()](First

• LAST()

• AGGR()

• ARRAY()

• Grouping functions

• CUBE()

• ROLLUP()

• [GROUPING SETS()](Grouping Sets)

• Standard functions

• [User-defined SQL functions](User Defined Functions)