Supported SQL

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

JSON

JSON support is documented separately in the MemCP MySQL- and Postgres-compatible JSON SQL