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” .
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” .