Supported SQL: Difference between revisions
Jump to navigation
Jump to search
(Created page with "The following SQL statements are supported: * SELECT FROM GROUP BY HAVING ORDER BY LIMIT OFFSET * UPDATE SET WHERE * DELETE FROM WHERE * INSERT INTO VALUES * CREATE TABLE * ALTER TABLE * CREATE DATABASE * CREATE USER * ALTER USER * SHOW DATABASES * SHOW TABLES * SHOW TABLE STATUS * SHOW VARIABLES * SET NAMES (no function) * DROP DATABASE * DROP TABLE * SET SESSION * LOCK TABLES (no function) * UNLOCK TABLES (no function) The following functions are supported: * CASE...") |
|||
| (One intermediate revision by the same user not shown) | |||
| Line 1: | Line 1: | ||
== Statements == | |||
The following SQL statements are supported: | The following SQL statements are supported: | ||
| Line 4: | Line 5: | ||
* UPDATE SET WHERE | * UPDATE SET WHERE | ||
* DELETE FROM WHERE | * DELETE FROM WHERE | ||
* INSERT INTO VALUES | * INSERT INTO VALUES ON DUPLICATE KEY UPDATE | ||
* CREATE TABLE | * CREATE TABLE | ||
* ALTER TABLE | * ALTER TABLE | ||
| Line 21: | Line 22: | ||
* UNLOCK TABLES (no function) | * UNLOCK TABLES (no function) | ||
== Expressions == | |||
The following functions are supported: | The following functions are supported: | ||
* CASE WHEN THEN ELSE END | * CASE WHEN THEN ELSE END | ||
* DATABASE | * DATABASE | ||
| Line 37: | Line 37: | ||
* CONCAT | * CONCAT | ||
* COALESCE | * COALESCE | ||
* UNIX_TIMESTAMP | |||
== Aggregates == | |||
The following aggregates are available: | The following aggregates are available: | ||
Latest revision as of 21:27, 19 May 2024
Statements
The following SQL statements are supported:
- SELECT FROM GROUP BY HAVING ORDER BY LIMIT OFFSET
- UPDATE SET WHERE
- DELETE FROM WHERE
- INSERT INTO VALUES ON DUPLICATE KEY UPDATE
- CREATE TABLE
- ALTER TABLE
- CREATE DATABASE
- CREATE USER
- ALTER USER
- SHOW DATABASES
- SHOW TABLES
- SHOW TABLE STATUS
- SHOW VARIABLES
- SET NAMES (no function)
- DROP DATABASE
- DROP TABLE
- SET SESSION
- LOCK TABLES (no function)
- UNLOCK TABLES (no function)
Expressions
The following functions are supported:
- CASE WHEN THEN ELSE END
- DATABASE
- PASSWORD (hashes a password for user authentication)
- FLOOR
- CEIL
- CEILING
- ROUND
- UPPER
- LOWER
- CAST AS UNSIGNED
- CAST AS CHAR CHARACTER SET utf8
- CONCAT
- COALESCE
- UNIX_TIMESTAMP
Aggregates
The following aggregates are available:
- COUNT
- SUM
- AVG
- MIN
- MAX