Supported SQL: Difference between revisions
Jump to navigation
Jump to search
| Line 5: | Line 5: | ||
* UPDATE SET WHERE | * UPDATE SET WHERE | ||
* DELETE FROM WHERE | * DELETE FROM WHERE | ||
* INSERT INTO VALUES ON DUPLICATE KEY UPDATE | * INSERT INTO VALUES ON DUPLICATE KEY UPDATE / INSERT ... ON CONFLICT (PostgreSQL) | ||
* INSERT IGNORE | |||
* CREATE TABLE | * CREATE TABLE | ||
* ALTER TABLE | * ALTER TABLE | ||
| Line 38: | Line 39: | ||
* COALESCE | * COALESCE | ||
* UNIX_TIMESTAMP | * UNIX_TIMESTAMP | ||
* LIKE | |||
* ILIKE | |||
== Aggregates == | == Aggregates == | ||
| Line 47: | Line 50: | ||
* MIN | * MIN | ||
* MAX | * MAX | ||
== Modifiers == | |||
* COLLATE | |||
Latest revision as of 01:06, 26 January 2026
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 / INSERT ... ON CONFLICT (PostgreSQL)
- INSERT IGNORE
- 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
- LIKE
- ILIKE
Aggregates
The following aggregates are available:
- COUNT
- SUM
- AVG
- MIN
- MAX
Modifiers
- COLLATE