Skip to content

Instantly share code, notes, and snippets.

@davidwaterston

davidwaterston/gist:3741564

Created September 18, 2012 06:27
Show Gist options
  • Save davidwaterston/3741564 to your computer and use it in GitHub Desktop.
Save davidwaterston/3741564 to your computer and use it in GitHub Desktop.
Download ZIP
MySQL: Check if a column exists in a table
Raw
gistfile1
select column_name
from information_schema.columns
where table_schema = '__database_name__'
and table_name = '__table_name__'
and column_name = '__column_name__'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment