Skip to content

Instantly share code, notes, and snippets.

@axe312ger

axe312ger/gist:7200243

Created October 28, 2013 16:39
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 axe312ger/7200243 to your computer and use it in GitHub Desktop.
Save axe312ger/7200243 to your computer and use it in GitHub Desktop.
Download ZIP
Get all sql tables who contain a specific column.
Raw
gistfile1.sql
SELECT DISTINCT TABLE_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME IN ('COLUMN_NAME')
AND TABLE_SCHEMA = 'TABLE_NAME';
@axe312ger
Copy link
Author

This can be used to convert all language neutral content to the default language in drupal.

"Update TABLE_NAME SET language = 'en' WHERE language = 'und';"

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment