Skip to content

Instantly share code, notes, and snippets.

@fprieur

fprieur/gist:7307757

Created November 4, 2013 19:18
Show Gist options

  • Select an option

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

Select an option

Learn more about clone URLs
Save fprieur/7307757 to your computer and use it in GitHub Desktop.
Download ZIP
Show tables by engine in MySQL
Raw
gistfile1.txt
SELECT table_name FROM INFORMATION_SCHEMA.TABLES
WHERE engine = 'InnoDB';
SELECT TABLE_NAME FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'dbname' AND engine = 'InnoDB';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment