Skip to content

Instantly share code, notes, and snippets.

@fprieur

fprieur/gist:7307757

Created November 4, 2013 19:18
Show Gist options
  • Save fprieur/7307757 to your computer and use it in GitHub Desktop.
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