Supported SQL

From MemCP

Revision as of 09:23, 19 May 2024 by Carli (talk | contribs) (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...")

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Jump to navigation Jump to search

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

The following aggregates are available:

COUNT
SUM
AVG
MIN
MAX

Retrieved from "https://www.memcp.org/index.php?title=Supported_SQL&oldid=86"