Skip to content

Instantly share code, notes, and snippets.

@tacsio

tacsio/ExtractMysql.sql

Last active December 17, 2015 09:09
Show Gist options
  • Save tacsio/5585561 to your computer and use it in GitHub Desktop.
Save tacsio/5585561 to your computer and use it in GitHub Desktop.
Download ZIP
Extract to file mysql
Raw
ExtractMysql.sql
SELECT * FROM table
where attr = x
INTO OUTFILE '/home/tarcisio.coutinho/Shared/inicio.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