Skip to content

Instantly share code, notes, and snippets.

@mogumogu2333

mogumogu2333/exportCSV.txt

Last active September 8, 2016 18:21
Show Gist options
  • Save mogumogu2333/8d10f169b9ad110e2baaa949a39fe57a to your computer and use it in GitHub Desktop.
Save mogumogu2333/8d10f169b9ad110e2baaa949a39fe57a to your computer and use it in GitHub Desktop.
Download ZIP
Raw
exportCSV.txt
# Export MYSQL tables into csv file
SELECT
orderNumber, status, orderDate, requiredDate, comments
FROM
orders
WHERE
status = 'Cancelled'
INTO OUTFILE 'C:/tmp/cancelled_orders.csv'
FIELDS ENCLOSED BY '"'
TERMINATED BY ';'
ESCAPED BY '"'
LINES TERMINATED BY '\r\n';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment