Luke Sims lukesims

Export a MySQL Query's Results to CSV with Column Headings and a Dynamic Filename

If we want to generate a CSV file directly from MySQL with column headings as the first row and a filename generated dynamically in the script, there are a few caveats which this snippet covers. These are described in full in long.sql amongst the comments and references.

long.sql - The script with all the comments and explanation of what/why.
short.sql - The script that has no comments and is as brief as possible to be used as a template.

Usage

Copy short.sql to a new .sql file in a location that is readable by the user running the MySQL process.

	# ------------------------------------------------------------------------------
	# .gitignore for OctoberCMS (http://octobercms.com/)
	# Based on https://gist.github.com/salcode/b515f520d3f8207ecd04 for WordPress
	# ------------------------------------------------------------------------------
	# By default all files are ignored.
	#
	# At the end of the file you will need to whitelist themes and plugins you want
	# to include in the repo.
	#
	# Update the {PLACEHOLDERS} to reflect your setup.