Supported SQL - Revision history

Carli: /* Statements */

2026-01-26T00:06:51Z

Statements

← Older revision		Revision as of 02:06, 26 January 2026
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

Carli: /* Expressions */

2024-05-19T19:27:34Z

Expressions

← Older revision		Revision as of 21:27, 19 May 2024
Line 37:		Line 37:
	* CONCAT		* CONCAT
	* COALESCE		* COALESCE
			* UNIX_TIMESTAMP

	== Aggregates ==		== Aggregates ==

Carli at 15:26, 19 May 2024

2024-05-19T15:26:03Z

← Older revision		Revision as of 17:26, 19 May 2024
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 38:		Line 38:
	* COALESCE		* COALESCE

			== Aggregates ==
	The following aggregates are available:		The following aggregates are available:

Carli: 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..."

2024-05-19T08:23:12Z

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

New page

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