Skip to content

Instantly share code, notes, and snippets.

@pcdinh

pcdinh/mysql_export.sql

Created October 3, 2009 19:40
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save pcdinh/200829 to your computer and use it in GitHub Desktop.
Save pcdinh/200829 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
mysql_export.sql
SELECT * INTO OUTFILE "users.txt"
FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n'
FROM cms.webusers
WHERE MONTH(created_time) = '01' AND YEAR(created_time) = '2009';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment