Query into outfile 'filename';
Query - query to be fired
filename - name of the file on which the data is to be written. Full path can also be given. Make sure that the folder is already in existence.
eg. select * from HOTEL_DETAILS into outfile 'C:/datafolder/sqldata.txt';
Further Reading:
http://gilfster.blogspot.com/2005/11/writing-sql-results-to-file.html
