The LOAD and UNLOAD instructions

Informix® provides two SQL instructions to export / import data from / into a database table: The UNLOAD instruction copies rows from a database table into a text file and the LOAD instructions insert rows from a text file into a database table.

MySQL does not provide LOAD and UNLOAD instructions.

Solution

LOAD and UNLOAD instructions are supported.