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;
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;