Skip to content

Instantly share code, notes, and snippets.

@axe312ger

axe312ger/gist:7200243

Created October 28, 2013 16:39
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save axe312ger/7200243 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
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

axe312ger commented Oct 28, 2013

Copy link
Copy Markdown
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