|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
|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.|
How helpful was this page?
What might be the problems?