Difference between revisions of "Selecting into a csv file"

From MyWiki
Jump to: navigation, search
(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...")
 
 
(One intermediate revision by the same user not shown)
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 '"'
Line 14: Line 15:
 
  UPDATE user SET File_priv = 'Y' WHERE User = 'db_user';
 
  UPDATE user SET File_priv = 'Y' WHERE User = 'db_user';
 
  FLUSH PRIVILEGES;
 
  FLUSH PRIVILEGES;
 +
 +
</source>

Latest revision as of 08:50, 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;
Retrieved from "https://wiki.twig.es/index.php?title=Selecting_into_a_csv_file&oldid=1048"