Skip to content

Instantly share code, notes, and snippets.

@wiesson

wiesson/to_innodb.sql

Created March 22, 2016 16:20
Show Gist options
  • Save wiesson/685f66f32ef63a3ead91 to your computer and use it in GitHub Desktop.
Save wiesson/685f66f32ef63a3ead91 to your computer and use it in GitHub Desktop.
Download ZIP
Covert all tables to innodb;
Raw
to_innodb.sql
SELECT CONCAT('ALTER TABLE ', TABLE_SCHEMA, '.', TABLE_NAME, ' engine=InnoDB;') FROM information_schema.TABLES WHERE ENGINE = 'MyISAM';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment