Skip to content

Instantly share code, notes, and snippets.

@r38y

r38y/gist:246590

Created December 1, 2009 20:00
Show Gist options
  • Save r38y/246590 to your computer and use it in GitHub Desktop.
Save r38y/246590 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
mysql> SELECT * INTO OUTFILE '/tmp/yeah.txt' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n' FROM winit_users;
Query OK, 343234 rows affected (7.48 sec)
* results in a 150 mb csv file -- pretty quick!
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment