SQL adaptation guide for Oracle MySQL 5.x, MariaDB 10.x / Data dictionary |
When creating a table, Informix® automatically adds a "ROWID" integer column (applies to non-fragmented tables only). The ROWID column is auto-filled with a unique number and can be used like a primary key to access a given row.
MySQL does not have an equivalent for the Informix ROWID pseudo-column.
ROWIDs are not supported. You must review the code using ROWIDs and use primary key columns instead.