Posted By

kaktos on 01/09/09


Tagged


Versions (?)

Who likes this?

2 people have marked this snippet as a favorite

nublaii
jeremydouglass


export mysql data to csv format


 / Published in: SQL
 

  1. SELECT * INTO OUTFILE '/tmp/stat.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n' FROM template_stats ORDER BY used_count DESC,favorite_count DESC;

Report this snippet  

You need to login to post a comment.