| SQL adaptation guide for Oracle MySQL 5.x, MariaDB 10.x / Data dictionary | |
Informix® uses the following form to identify a SQL object:
[database[@dbservername]:][{owner|"owner"}.]identifier
With MySQL, an object name takes the following form:
[database.]identifier
As a general rule, to write portable SQL, you should only use simple database object names without any database, server or owner qualifier and without quoted identifiers.