Standard SQL and the extention

 Alinous-Core support SQL based on PostgreSQL.

Outline of supporting SQL

The outline of supported SQL is below.

  • SELECT
    • DISTINCT
    • ALIAS
    • Subquery
    • Embeded function supported by DBMS
    • FROM
    • INNER JOIN
    • LEFT [OUTER] JOIN
    • RIGHT [OUTER] JOIN
    • CROSS JOIN
    • WHERE
    • WHERE INNER JOIN
    • ORDER BY ASC
    • ORDER BY DESC
    • LIMIT
    • OFFET
  • INSERT
    • Subquery
    • VALUES
  • UPDATE
    • Subquery
    • SET
    • WHERE
  • DELETE
    • Delete all
    • WHERE
  • BEGIN
  • COMMIT
  • ROLLBACK
  • PREPARE TRANSACTION
  • COMMIT PREPARED
  • ROLLBACK PREPARED
  • CREATE TABLE
  • DROP TABLE
  • ALTER

Detail of SELECT

 The usage of SELECT is below.

And the Alinous-Core supports next functions.

  • JOIN (LEFT, RIGHT, INNER, CROSS JOIN)
  • Subquery
  • Row lock(FOR UPDATE, FOR SHARE)

 Row numbers to fetch is specified like below.

"IN" operator and script

 The "IN" operator has some way to use it. The examples are below.

 The values in the "IN" operator is written as hard coding.

 Using with an array script variable.

 Using with subquery.

Detail of INSERT

  The usage of INSERT is below.

 You can use script variables in the "VALUES" section.

Detail of UPDATE

  The usage of UPDATE is below.

Detail of DELETE

  The usage of DELETE is below.

 


Go to Top