Exporting Data : Import Export Data « MySQL Utilities « MySQL Tutorial

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

The command to export data to a text file is similar to the standard SELECT command.

MySQL creates a 'tab delimited' file by default.

SELECT <columns>
FROM <table_name>
INTO OUTFILE <file_name>

SELECT
employee.id,
employee.first_name,
employee.last_name,
employee.start_date,
employee.salary,
employee.city
FROM employee INTO OUTFILE 'c:\\employee.txt';