Skip to content

Instantly share code, notes, and snippets.

@stephenhardy

stephenhardy/findTablesWithColumnsMySQL.sql

Created May 30, 2016 10:41
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save stephenhardy/a89d672fd9f23b0787d9aebff045940d to your computer and use it in GitHub Desktop.
Save stephenhardy/a89d672fd9f23b0787d9aebff045940d to your computer and use it in GitHub Desktop.
Download ZIP
Find all mysql database tables with specific column names
Raw
findTablesWithColumnsMySQL.sql
SELECT DISTINCT TABLE_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME IN ('columnA','ColumnB')
AND TABLE_SCHEMA='YourDatabase';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment