Difference between revisions of "Mysql"
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;") |
|||
| Line 3: | Line 3: | ||
LINES TERMINATED BY '\n' | LINES TERMINATED BY '\n' | ||
FROM test_table; | 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; | ||
Revision as of 14:03, 26 August 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;
