Skip to main content

Comma Separated Values Format for MySQL Data

Comma Separated Values format for MySQL Data

mysql> SELECT * INTO OUTFILE '/tmp/result.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n' FROM response_answers;