Posted By

kaktos on 01/09/09


Versions (?)

Who likes this?

2 people have marked this snippet as a favorite


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.