Importing data : Import Export Data « MySQL Utilities « MySQL Tutorial

1. MySQL Tutorial
2. MySQL Utilities
3. Import Export Data

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);