I am using MySQL Workbench 5.2 OSS to view and when necessary, remove records from a table via SQL Statements.
I am trying to run the statement below to export all records from a table named master_rate_records as a text file with the same name, but it is telling me there is an error in my SQL syntax (error code 1604).
I've tried to reword it a few times with no luck. I figured it was time to ask the experts.
Thanks in advance!
SELECT * FROM master_rate_records
INTO OUTFILE 'master_rate_records.txt'
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n'