Difference between revisions of "Selecting into a csv file"
From MyWiki
(Created page with " SELECT a,b,a+b INTO OUTFILE '/tmp/result.txt' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n' FROM test_table; SELECT order_id,product_n...") |
|||
| Line 1: | Line 1: | ||
| + | <source lang="sql"> | ||
SELECT a,b,a+b INTO OUTFILE '/tmp/result.txt' | SELECT a,b,a+b INTO OUTFILE '/tmp/result.txt' | ||
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' | FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' | ||
Revision as of 08:39, 23 September 2014
SELECT a,b,a+b INTO OUTFILE '/tmp/result.txt' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n' FROM test_table; SELECT order_id,product_name,qty FROM orders INTO OUTFILE '/tmp/orders.csv' FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n' USE mysql; UPDATE USER SET File_priv = 'Y' WHERE USER = 'db_user'; FLUSH PRIVILEGES;
