Compatibility with MySQL

SQL statement type

SQL syntax

Compatible

Remarks

Data definition statements

ALTER DATABASE

Y

ALTER EVENT

Y

Disallowed

ALTER FUNCTION

Y

ALTER INSTANCE

Y

Disallowed

ALTER PROCEDURE

Y

ALTER SERVER

Y

Disallowed

ALTER TABLE

Y

ALTER TABLESPACE

Y

Disallowed

ALTER VIEW

Y

CREATE DATABASE

Y

CREATE EVENT

Y

CREATE FUNCTION

Y

CREATE INDEX

Y

CREATE PROCEDURE

CREATE FUNCTION

Y

CREATE SERVER

Y

Disallowed

CREATE SPATIAL REFERENCE SYSTEM

Y

Disallowed

CREATE TABLE

Y

CREATE TABLESPACE

Y

Disallowed

CREATE TRIGGER

Y

CREATE VIEW

Y

DROP DATABASE

Y

DROP EVENT

Y

DROP FUNCTION

Y

DROP INDEX

Y

DROP PROCEDURE

DROP FUNCTION

Y

DROP SERVER

Y

Disallowed

DROP SPATIAL REFERENCE SYSTEM

Y

Disallowed

DROP TABLE

Y

DROP TRIGGER

Y

DROP VIEW

Y

RENAME TABLE

Y

TRUNCATE TABLE

Y

Data manipulation statements

CALL

Y

DELETE

Y

DO

Y

HANDLER

Y

IMPORT TABLE

Y

Disallowed

INSERT

Y

INTERSECT clause

Y

This clause is not supported.

LOAD DATA

Y

Disallowed

LOAD XML

Y

Disallowed

REPLACE

Y

SELECT

Y

Subqueries

Y

UPDATE

Y

UNION clause

Y

WITH (common table expressions)

Y

Transactional and locking statements

START TRANSACTION, COMMIT, and ROLLBACK

Y

SAVEPOINT, ROLLBACK TO SAVEPOINT, and RELEASE SAVEPOINT

Y

LOCK INSTANCE FOR BACKUP and UNLOCK INSTANCE

Y

Disallowed

LOCK TABLES and UNLOCK TABLES

Y

SET TRANSACTION

Y

Statements for controlling replica servers

CHANGE MASTER TO

Y

Disallowed

CHANGE REPLICATION FILTER

Y

Disallowed

CHANGE REPLICATION SOURCE TO

Y

Disallowed

START REPLICA

Y

Disallowed

START SLAVE

Y

Disallowed

STOP REPLICA

Y

Disallowed

STOP SLAVE

Y

Disallowed

Statements for controlling group replication

START GROUP_REPLICATION

Y

Disallowed

STOP GROUP_REPLICATION

Y

Disallowed

Prepared statements

PREPARE

Y

EXECUTE

Y

DEALLOCATE PREPARE

Y

Database administration statements: account management statements

ALTER USER

Y

CREATE ROLE

Y

CREATE USER

Y

DROP ROLE

Y

DROP USER

Y

GRANT

Y

RENAME USER

Y

REVOKE

Y

SET DEFAULT ROLE

Y

SET PASSWORD

Y

SET ROLE

Y

Database administration statements: table maintenance statements

ANALYZE TABLE

Y

CHECK TABLE

Y

CHECKSUM TABLE

Y

OPTIMIZE TABLE

Y

REPAIR TABLE

Y

Database administration statements: component, plug-in, and loadable function statements

CREATE FUNCTION statement for loadable functions

Y

DROP FUNCTION statement for loadable functions

Y

INSTALL COMPONENT

Y

INSTALL PLUGIN

Y

UNINSTALL COMPONENT

Y

UNINSTALL PLUGIN

Y

Database administration statements: SET statements

SET syntax

Y

SET CHARACTER

Y

SET NAMES

Y

Database administration statements: SHOW statements

SHOW BINARY LOGS

Y

Only users who have the REPLICATION CLIENT permission can execute this statement.

SHOW BINLOG EVENTS

Y

Only users who have the REPLICATION SLAVE permission can execute this statement.

SHOW CHARACTER SET

Y

SHOW COLLATION

Y

SHOW COLUMNS

Y

SHOW CREATE DATABASE

Y

SHOW CREATE EVENT

Y

SHOW CREATE PROCEDURE

Y

SHOW CREATE TABLE

Y

SHOW CREATE TRIGGER

Y

SHOW CREATE USER

Y

SHOW CREATE VIEW

Y

SHOW DATABASES

Y

SHOW ENGINES

Y

SHOW ERRORS

Y

SHOW EVENTS

Y

SHOW FUNCTION CODE

Y

SHOW FUNCTION STATUS

Y

SHOW GRANTS

Y

SHOW INDEX

Y

SHOW MASTER STATUS

Y

SHOW OPEN TABLES

Y

SHOW PLUGINS

Y

SHOW PRIVILEGES

Y

SHOW PROCEDURE CODE

Y

SHOW PROCEDURE STATUS

Y

SHOW PROCESSLIST

Y

SHOW PROFILE

Y

SHOW PROFILES

Y

SHOW SLAVE | REPLICA STATUS

Y

SHOW STATUS

Y

SHOW TABLE STATUS

Y

SHOW TABLES

Y

SHOW TRIGGERS

Y

SHOW VARIABLES

Y

SHOW WARNINGS

Y

Utility statements

DESCRIBE

Y

EXPLAIN

Y

HELP

Y

USE

Y

SQL statement type

SQL syntax

Compatible

Remarks

Data definition statements

ALTER DATABASE

Y

ALTER EVENT

N

This feature is not supported.

ALTER FUNCTION

Y

ALTER INSTANCE

N

This feature is not supported.

ALTER PROCEDURE

Y

ALTER SERVER

N

This feature is not supported.

ALTER TABLE

Y

ALTER TABLESPACE

N

This feature is not supported.

ALTER VIEW

Y

CREATE DATABASE

Y

CREATE EVENT

N

This feature is not supported.

CREATE FUNCTION

Y

CREATE INDEX

Y

CREATE PROCEDURE

CREATE FUNCTION

Y

CREATE SERVER

N

This feature is not supported.

CREATE SPATIAL REFERENCE SYSTEM

N

This feature is not supported.

CREATE TABLE

Y

CREATE TABLESPACE

N

This feature is not supported.

CREATE TRIGGER

Y

CREATE VIEW

Y

DROP DATABASE

Y

DROP EVENT

N

This feature is not supported.

DROP FUNCTION

Y

DROP INDEX

Y

DROP PROCEDURE

DROP FUNCTION

Y

DROP SERVER

N

This feature is not supported.

DROP SPATIAL REFERENCE SYSTEM

N

This feature is not supported.

DROP TABLE

Y

DROP TRIGGER

Y

DROP VIEW

Y

RENAME TABLE

Y

TRUNCATE TABLE

Y

Data manipulation statements

CALL

Y

DELETE

Y

DO

Y

EXCEPT clause

Y

HANDLER

N

This feature is not supported.

IMPORT TABLE

N

This feature is not supported.

INSERT

Y

INTERSECT clause

Y

LOAD DATA

N

This feature is supported. By default, this feature is disabled.

LOAD XML

N

This feature is not supported.

REPLACE

Y

SELECT

Y

Subqueries

Y

UPDATE

Y

UNION clause

Y

WITH (common table expressions)

Y

Transactional and locking statements

START TRANSACTION, COMMIT, and ROLLBACK

Y

SAVEPOINT, ROLLBACK TO SAVEPOINT, and RELEASE SAVEPOINT

Y

LOCK INSTANCE FOR BACKUP and UNLOCK INSTANCE

N

This feature is not supported.

LOCK TABLES and UNLOCK TABLES

N

This feature is not supported.

SET TRANSACTION

Y

Statements for controlling replica servers

CHANGE MASTER TO

N

This feature is not supported.

CHANGE REPLICATION FILTER

N

This feature is not supported.

CHANGE REPLICATION SOURCE TO

N

This feature is not supported.

START REPLICA

N

This feature is not supported.

START SLAVE

N

This feature is not supported.

STOP REPLICA

N

This feature is not supported.

STOP SLAVE

N

This feature is not supported.

Statements for controlling group replication

START GROUP_REPLICATION

N

This feature is not supported.

STOP GROUP_REPLICATION

N

This feature is not supported.

Prepared statements

PREPARE

Y

EXECUTE

Y

DEALLOCATE PREPARE

Y

Database administration statements: account management statements

ALTER USER

Y

CREATE ROLE

Y

CREATE USER

Y

DROP ROLE

Y

DROP USER

Y

GRANT

Y

RENAME USER

Y

REVOKE

Y

SET DEFAULT ROLE

Y

SET PASSWORD

Y

SET ROLE

Y

Database administration statements: table maintenance statements

ANALYZE TABLE

Y

CHECK TABLE

Y

CHECKSUM TABLE

Y

OPTIMIZE TABLE

Y

REPAIR TABLE

N

This feature is not supported.

Database administration statements: component, plug-in, and loadable function statements

CREATE FUNCTION statement for loadable functions

Y

DROP FUNCTION statement for loadable functions

Y

INSTALL COMPONENT

N

This feature is not supported.

INSTALL PLUGIN

N

This feature is not supported.

UNINSTALL COMPONENT

N

This feature is not supported.

UNINSTALL PLUGIN

N

This feature is not supported.

Database administration statements: SET statements

SET syntax

Y

SET CHARACTER

Y

SET NAMES

Y

Database administration statements: SHOW statements

SHOW BINARY LOGS

Y

Only users who have the REPLICATION CLIENT permission can execute this statement.

SHOW BINLOG EVENTS

Y

Only users who have the REPLICATION SLAVE permission can execute this statement.

SHOW CHARACTER SET

Y

SHOW COLLATION

Y

SHOW COLUMNS

Y

SHOW CREATE DATABASE

Y

SHOW CREATE EVENT

Y

SHOW CREATE PROCEDURE

Y

SHOW CREATE TABLE

Y

SHOW CREATE TRIGGER

Y

SHOW CREATE USER

Y

SHOW CREATE VIEW

Y

SHOW DATABASES

Y

SHOW ENGINES

Y

SHOW ERRORS

Y

SHOW EVENTS

Y

SHOW FUNCTION CODE

Y

SHOW FUNCTION STATUS

Y

SHOW GRANTS

Y

SHOW INDEX

Y

SHOW MASTER STATUS

Y

SHOW OPEN TABLES

Y

SHOW PLUGINS

Y

SHOW PRIVILEGES

Y

SHOW PROCEDURE CODE

Y

SHOW PROCEDURE STATUS

Y

SHOW PROCESSLIST

Y

SHOW PROFILE

Y

SHOW PROFILES

Y

SHOW RELAYLOG EVENTS

Y

SHOW REPLICAS

Y

SHOW SLAVE HOSTS | SHOW REPLICAS

N

This feature is not supported.

SHOW REPLICA STATUS

Y

SHOW SLAVE | REPLICA STATUS

Y

SHOW STATUS

Y

SHOW TABLE STATUS

Y

SHOW TABLES

Y

SHOW TRIGGERS

Y

SHOW VARIABLES

Y

SHOW WARNINGS

Y

Utility statements

DESCRIBE

Y

EXPLAIN

Y

HELP

Y

USE

Y