Skip to content

Instantly share code, notes, and snippets.

@McKinneyDigital

McKinneyDigital/sql-csv-export.sql

Created June 6, 2012 19:56
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save McKinneyDigital/2884338 to your computer and use it in GitHub Desktop.
Save McKinneyDigital/2884338 to your computer and use it in GitHub Desktop.
Download ZIP
Export a CSV of user info from database table in a single SQL Query
Raw
sql-csv-export.sql
SELECT id,email FROM users INTO OUTFILE '/tmp/users.csv' FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment