Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

sql query result to csv file directly from console

Tags:

sql

csv

I want to export select query result with two columns to csv file. I don't have phpmyadmin or tools like this. I have to run my query directly from console. Can someone give me a hint how can I do this?

like image 654
fortegente Avatar asked Feb 11 '23 03:02

fortegente


1 Answers

You could try to use this command:

SELECT field_1,field_2
FROM table_name
INTO OUTFILE '/tmp/output.csv'
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n';
like image 189
teoreda Avatar answered Feb 13 '23 03:02

teoreda