How to Export SQL Query to TXT Using Command Line
20,693
look at link
you only need to add this to the query
select * from table INTO OUTFILE '/tmp/myfilename.txt'
you can improve this to csv file (using it in excel latter)
like :
INTO OUTFILE '/tmp/myfilename.csv'
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n'
Author by
X10nD
Updated on July 09, 2022Comments
-
X10nD almost 2 years
I want to export
select * from table
results to a text file from the command line in linux. How should I do this?Thanks, Jean