SQL CSV Export
Nothing new here, but had forgot how easy it is to export to csv in mysql
SELECT * INTO OUTFILE 'result.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n' FROM my_table;
Note that this file will be created on the mysql server, not the client.