Skip to content

Instantly share code, notes, and snippets.

@oreales

oreales/mysql-select-to-csv.mysql

Created November 11, 2016 20:01
Show Gist options
  • Save oreales/3f388f4a28ba55fa0d430bf6783dca5e to your computer and use it in GitHub Desktop.
Save oreales/3f388f4a28ba55fa0d430bf6783dca5e to your computer and use it in GitHub Desktop.
Download ZIP
Exportando desde MySQL a csv
Raw
mysql-select-to-csv.mysql
#Por ejemplo para importar a Apple Numbers
SELECT *
FROM orders
INTO OUTFILE '/tmp/orders.csv'
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment