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