mySQL csv export

#mySQL CSV Exports
## On the command line
mysql -u exampleuser -p letmein exampledb -B -e "select * from \`person\`;" | sed ’s/\t/”,”/g;s/^/”/;s/$/”/;s/\n//g’ > filename.csv

## and with a direct mySQL query
SELECT * INTO OUTFILE '/tmp/result.txt'
  FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
  LINES TERMINATED BY '\n'
  FROM test_table WHERE 'all'='good';