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>
SELECTemployee.id,employee.first_name,employee.last_name,employee.start_date,employee.salary,employee.cityFROM employee INTO OUTFILE 'c:\employee.txt';
Name (required)
email (will not be published) (required)
Website
