reyesyang · February 25, 2014 09:00
diff --git a/mysql_outfile.sql b/mysql_outfile.sql
 SELECT id, username, (total_point - spent_point) AS point
 FROM users
 ORDER BY point DESC
 LIMIT 50
 INTO OUTFILE '/tmp/bbs_points_top50.csv'
 FIELDS TERMINATED BY ','
 ENCLOSED BY '"'
 LINES TERMINATED BY '\n'
 ;
	SELECT id, username, (total_point - spent_point) AS point
	FROM users
	ORDER BY point DESC
	LIMIT 50
	INTO OUTFILE '/tmp/bbs_points_top50.csv'
	FIELDS TERMINATED BY ','
	ENCLOSED BY '"'
	LINES TERMINATED BY '\n'
	;