Skip to content

Instantly share code, notes, and snippets.

@tilhom
Created March 19, 2019 07:36
Show Gist options
  • Save tilhom/099f3658cc248cb8cefd2d9851c017da to your computer and use it in GitHub Desktop.
Save tilhom/099f3658cc248cb8cefd2d9851c017da to your computer and use it in GitHub Desktop.
to get field names from mysql table
SELECT COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = 'committee' AND TABLE_NAME = 'users'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment