Tag Archives: csv

Export MySQL table as csv file

Exporting from an RDBMS always depends on the syntax of the specific RDBMS in question.  For MySQL, here is how to transform a SELECT statement into a CSV export: SELECT a,b INTO OUTFILE ‘/tmp/result.csv’ FIELDS TERMINATED BY ‘,’ OPTIONALLY ENCLOSED … Continue reading

Posted in Data Warehouse, Dedicated Servers, Hosting Support, Managed Hosting | Tagged , | Leave a comment