Export the query result in a temporary file
select video_file from videos INTO OUTFILE ‘/tmp/video1.txt’;
Query Above exports all the rows for coulmn video_file into a text file “/tmp/video1.txt” .
Categories: Mysql
satishgaudo.com
Understanding technology