Selecting into a csv file - Revision history

George2 at 08:50, 23 September 2014

2014-09-23T08:50:06Z

George2 at 08:39, 23 September 2014

2014-09-23T08:39:16Z

George2: 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..."

2014-08-26T14:06:13Z

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..."

New page

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;

← Older revision		Revision as of 08:50, 23 September 2014
Line 15:		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>

← Older revision		Revision as of 08:39, 23 September 2014
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 '"'