Skip to content

Instantly share code, notes, and snippets.

@dungmanh88

dungmanh88/Check if DB has engine MyISAM

Created October 1, 2016 15:35
Show Gist options
  • Save dungmanh88/042cbb9c2e0f3d05d3da522fdc94570d to your computer and use it in GitHub Desktop.
Save dungmanh88/042cbb9c2e0f3d05d3da522fdc94570d to your computer and use it in GitHub Desktop.
Download ZIP
Check if DB has engine MyISAM
Raw
Check if DB has engine MyISAM
select table_schema, table_name, engine from information_schema.tables where engine != 'InnoDB' and table_schema not in ('mysql', 'performance_schema', 'information_schema');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment