dpdexter/gist:164803d46d7b495f87c2

Created February 20, 2015 20:08

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/dpdexter/164803d46d7b495f87c2.js"></script>
Save dpdexter/164803d46d7b495f87c2 to your computer and use it in GitHub Desktop.

Download ZIP

show table field names

Raw

gistfile1.txt

	SELECT `COLUMN_NAME`
	FROM `INFORMATION_SCHEMA`.`COLUMNS`
	WHERE `TABLE_SCHEMA`='yourdbname'
	AND `TABLE_NAME`='yourtablename';

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