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?
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';
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With