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 20: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