MySQL | AnalyticDB for MySQL | Description |
ALTER DATABASE | Not supported | Modifies the attributes of a database. |
ALTER EVENT | Not supported | Modifies one or more characteristics of an existing event. |
ALTER FUNCTION | Not supported | Modifies the definition of a function. |
ALTER LOGFILE GROUP | Not supported | Modifies a log file group. |
ALTER PROCEDURE | Not supported | Modifies the characteristics of a stored procedure. |
ALTER SERVER | Not supported | Modifies the information of a server. |
ALTER TABLE | Supported. For more information, see ALTER TABLE. Note The following operations are not supported:
| Modifies the definition of a table. |
ALTER TABLE Partition | Supported | Modifies partitions of a table. |
ALTER TABLESPACE | Not supported | Modifies tablespaces, adds data files, or removes data files from tablespaces. |
ALTER VIEW | Not supported | Modifies the definition of a view. |
CREATE DATABASE | Supported. For more information, see CREATE DATABASE. Note Values of the CHARACTER SET and COLLATE types are ignored in AnalyticDB for MySQL. | Creates a database. |
CREATE EVENT | Not supported | Creates an event. |
CREATE FUNCTION | Not supported | Creates a function. |
CREATE INDEX | Supported. For more information, see Create an index. Note By default, | Creates an index. |
CREATE LOGFILE GROUP | Not supported | Creates a log file group or adds a file to an existing log file group. |
CREATE PROCEDURE | Not supported | Creates a stored procedure. |
CREATE SERVER | Not supported | Creates a server for the storage engine. |
CREATE TABLE | Supported. For more information, see CREATE TABLE. | Creates a table. |
CREATE TEMPORARY TABLE | Not supported | Creates a temporary table. |
CREATE TABLE ... LIKE | Supported | Uses the LIKE syntax to create a table. |
CREATE TABLE ... SELECT | Supported. For more information, see CREATE TABLE AS SELECT (CTAS). | Uses the SELECT syntax to create a table. |
FOREIGN KEY Constraints | Not supported | Configures limits for foreign keys. |
CREATE TABLESPACE | Not supported | Creates a tablespace. |
CREATE TRIGGER | Not supported | Creates a trigger. |
CREATE VIEW | Supported. For more information, see CREATE VIEW. | Creates a view. |
DROP DATABASE | Supported. For more information, see DROP DATABASE. Note To protect data, before you delete a database from AnalyticDB for MySQL, you must delete tables stored in the database. | Deletes a database. |
DROP EVENT | Not supported | Deletes an event. |
DROP FUNCTION | Not supported | Deletes a function. |
DROP INDEX | Not supported | Deletes an index. |
DROP LOGFILE GROUP | Not supported | Deletes a log file group. |
DROP PROCEDURE | Not supported | Deletes a stored procedure. |
DROP SERVER | Not supported | Deletes a server. |
DROP TABLE | Supported | Deletes one or more tables. |
DROP TABLESPACE | Not supported | Deletes a tablespace. |
DROP TRIGGER | Not supported | Deletes a trigger. |
DROP VIEW | Supported. For more information, see DROP VIEW. | Deletes one or more views. |
RENAME TABLE | Supported | Renames one or more tables. |
TRUNCATE TABLE | Supported | Clears all rows of a table. |