Selecting into a csv file

From MyWiki
Jump to: navigation, search
 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;