CODEWITHSUNDEEP
sqlcsv
fortegente
fortegente

Reputation: 1391

sql query result to csv file directly from console

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?

Upvotes: 4

Views: 2521

Answers (1)

teoreda
teoreda

Reputation: 2570

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';

Upvotes: 9

Related Questions