Skip to content

Instantly share code, notes, and snippets.

@wouerner

wouerner/select name of columns table mysql

Created December 10, 2016 19:03
Show Gist options
  • Save wouerner/fc6f13192b6f8baea62d0a9ab109881e to your computer and use it in GitHub Desktop.
Save wouerner/fc6f13192b6f8baea62d0a9ab109881e to your computer and use it in GitHub Desktop.
Download ZIP
Raw
select name of columns table mysql
SELECT `COLUMN_NAME`
FROM `INFORMATION_SCHEMA`.`COLUMNS`
WHERE `TABLE_SCHEMA`='yourdatabasename'
AND `TABLE_NAME`='yourtablename';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment