MySQL AnalyticDB for MySQL Description
CALL Not supported Calls a stored procedure.
DELETE Supported. For more information, see DELETE. Deletes rows from a table.
DO Not supported Executes an expression but returns no result.
HANDLER Not supported Accesses the storage engine interface of the table.
INSERT Supported. For more information, see INSERT INTO. Inserts new rows into an existing table.
INSERT ... SELECT Supported. For more information, see INSERT SELECT FROM. Inserts rows into a table based on the results of SELECT. You can select one or more tables to insert rows.
INSERT ... ON DUPLICATE KEY UPDATE Supported
Note
  • This feature is supported only by clusters of V3.1.3.5 and later.
  • You cannot update primary key columns.
If you specify the ON DUPLICATE KEY UPDATE clause and the row to be inserted causes duplicate values in the unique index or primary key, the original row is updated.
INSERT DELAYED Not supported The DELAYED clause is a MySQL extension of standard SQL.
LOAD DATA Supported Reads rows from a text file into a table at a high speed.
LOAD XML Not supported Reads data from an XML file into a table.
REPLACE Supported. For more information, see REPLACE INTO. The operation of REPLACE is the same as that of INSERT. The difference is that if an old row in the table has the same value as the new row of PRIMARY KEY or UNIQUE index, the original row is deleted before the new row is inserted.
SELECT. For more information, see Syntax. SELECT ... INTO Not supported Stores the query results in variables or writtes the query results to files.
JOIN Supported Connects two subqueries.
UNION Supported. For more information, see UNION, INTERSECT, and EXCEPT. Merges results from multiple SELECT statements into one result set.
Subquery. For more information, see Subqueries. The Subquery as Scalar Operand Supported The subquery as scalar operand that has equal signs (=).
Comparisons Using Subqueries Supported The subquery that has a comparator.
Subqueries with ANY, IN, or SOME Supported The subquery that has ANY, IN, or SOME.
Subqueries with ALL Supported The subquery that has ALL.
Row Subqueries Supported The row subquery.
Subqueries with EXISTS or NOT EXISTS Supported The subquery that has EXISTS or NOT EXISTS.
Correlated Subqueries Supported The subquery includes a reference to query the table at the external layer.
Derived Tables Supported The subquery in the FROM clause.
UPDATE Supported. For more information, see UPDATE.
Note You cannot update primary key columns.
Modifies data in a table.