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
FROM
INTO OUTFILE
SELECT
employee.id,
employee.first_name,
employee.last_name,
employee.start_date,
employee.salary,
employee.city
FROM employee INTO OUTFILE 'c:\\employee.txt';