Mega Code Archive

 

Categories / MySQL Tutorial / MySQL Utilities

 

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