MySQL Utilities MySQL Tutorial

Importing data is a very simliar process to exporting.
The syntax for importing a file is:

LOAD DATA INFILE 'file_name.txt'
INTO TABLE tbl_name (field1, field2...etc)

LOAD DATA INFILE 'c:\\employee.txt'
INTO TABLE employee (id, first_name, last_name, start_date, salary, city);