Friday, June 1, 2012

MySQL: Directing Query Output to File

In MySQL, to direct query output to a file:

mysql> SELECT * FROM people INTO OUTFILE '/tmp/filename';

Reference: www.tech-recipes.com/rx/1475/save-mysql-query-results-into-a-text-or-csv-file/

No comments:

Post a Comment