Return to Snippet

Revision: 50200
at August 16, 2011 01:16 by Jamie


Initial Code
SELECT 
id, 
email 

INTO OUTFILE '/tmp/csv_users.txt' 
FIELDS TERMINATED BY '\t' 
LINES TERMINATED BY '\n'

FROM users 

ORDER BY created_at
DESC LIMIT 10

Initial URL

                                

Initial Description
Simple example of how you can output a query as

Initial Title
Save a MySQL Query as a Tab or Comma separated file

Initial Tags
mysql

Initial Language
MySQL