Skip to content

Instantly share code, notes, and snippets.

@jmilagroso

jmilagroso/MySQLToCSV

Created June 18, 2014 05:05
Show Gist options
  • Save jmilagroso/871dab467ebf42ce824d to your computer and use it in GitHub Desktop.
Save jmilagroso/871dab467ebf42ce824d to your computer and use it in GitHub Desktop.
Download ZIP
Export data as CSV
Raw
MySQLToCSV
SELECT * INTO OUTFILE 'C:/export/users.csv'
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
ESCAPED BY '\\'
LINES TERMINATED BY '\n'
FROM users;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment