Menu
AWS Schema Conversion Tool
User Guide (Version 1.0)

Conversion Issues with INSERT

Issue 6172: MySQL doesn't support the INSERT statement with the RETURNING option

To convert this operation, change the INSERT statement with the RETURNING clause into an INSERT statement with following SELECT statements, and use the same key conditions in each SELECT. You can also use the last value that was generated by any AUTO_INCREMENT column in the key condition.

Related Topics