filviu/export-csv.sql

Created September 1, 2014 06:52

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/filviu/51c92e4fbb9afc00236f.js"></script>
Save filviu/51c92e4fbb9afc00236f to your computer and use it in GitHub Desktop.

Download ZIP

Export mysql data directly to csv from the command line. From http://www.tech-recipes.com/rx/1475/save-mysql-query-results-into-a-text-or-csv-file/

Raw

export-csv.sql

	SELECT order_id,product_name,qty
	FROM orders
	INTO OUTFILE '/tmp/orders.csv'
	FIELDS TERMINATED BY ','
	ENCLOSED BY '"'
	LINES TERMINATED BY '\n'

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment