Monthly Archives: August 2018

Dumping a SQL query into a CSV file in MySQL

Yet another note to myself… SELECT order_id,product_name,qty FROM orders INTO OUTFILE ‘/tmp/orders.csv’ FIELDS TERMINATED BY ‘,’ ENCLOSED BY ‘”‘ LINES TERMINATED BY ‘\n’ Credit to (Since this apparently doesn’t work with one of the versions of MySQL I use, … Continue reading

Posted in Technology | Tagged | Leave a comment