LinuxQuestions.org - SQL to CSV; simple question?

- Programming (http://www.linuxquestions.org/questions/programming-9/)

- - SQL to CSV; simple question? (http://www.linuxquestions.org/questions/programming-9/sql-to-csv%3B-simple-question-736552/)

SQL to CSV; simple question?

I have an SQL database running on a remote host (I don't know how I would access files saved to that machine).

How do I save (or get) the query output to a CSV file?

If the remote machine allows client connections you could login with (at least with mysql):

Code:

mysql --host=xxx.xxx.xxx.xxx --user=dbaselogin --password=mypassword

If you can't there is always the option of scp, ftp or http to transfer the resulting text file.

Try:

Code:

SELECT order_id,product_name,qty

FROM orders

INTO OUTFILE '/tmp/orders.csv'

FIELDS TERMINATED BY ','

ENCLOSED BY '"'

LINES TERMINATED BY '\n';

on the client computer.

Copied from http://www.tech-recipes.com/rx/1475/...t-or-csv-file/

Regards,
Stefan

I couldn't write using the output command. If I had I don't know how I would have gotten the file.

Instead I just used redirects:

Code:

mysql --host=xxx.xxx.xxx.xxx --user=dbaselogin --password=mypassword < mysqlscript.sql > myoutputfile.csv

Thank you for your tips and suggestions.