Supported SQL

From MemCP
Jump to navigation Jump to search

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