Difference between revisions of "Mysql"

Revision as of 14:06, 26 August 2014

@@ Line 1: / Line 1: @@
- SELECT a,b,a+b INTO OUTFILE '/tmp/result.txt'
+[[ Selecting into a csv file ]]
-  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;