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 without returning a result.
HANDLER Not supported Accesses the storage engine interface of a 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. For more information, see INSERT ON DUPLICATE KEY UPDATE.
Note
  • This statement can be used only for clusters of V3.1.3.5 and later.
  • Primary key columns cannot be updated.
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 the 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 writes the query results to files.
JOIN Supported. For more information, see JOIN. 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 Performs a subquery as scalar operand that has equal signs (=).
Comparisons Using Subqueries Supported Performs a subquery that has a comparator.
Subqueries with ANY, IN, or SOME Supported Performs a subquery that has ANY, IN, or SOME.
Subqueries with ALL Supported Performs a subquery that has ALL.
Row Subqueries Supported Performs a row subquery.
Subqueries with EXISTS or NOT EXISTS Supported Performs a subquery that has EXISTS or NOT EXISTS.
Correlated Subqueries Supported Performs a subquery that includes a reference to query the table at the external layer.
Derived Tables Supported Performs a subquery in the FROM clause.
UPDATE Supported. For more information, see UPDATE.
Note
  • Primary key columns cannot be updated.
  • SQL statements cannot be updated in batches.
Modifies data in a table.