Skip to content

Instantly share code, notes, and snippets.

@yellow5

yellow5/mysql_snip.sql

Created February 17, 2011 21:35
Show Gist options
  • Save yellow5/832761 to your computer and use it in GitHub Desktop.
Save yellow5/832761 to your computer and use it in GitHub Desktop.
Download ZIP
An example of a quick way to list tables in a database containing a given column name
Raw
mysql_snip.sql
select table_name
from `information_schema`.`columns`
where table_schema = 'DB_NAME' and column_name = 'DESIRED_COLUMN_NAME';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment