Skip to content

Instantly share code, notes, and snippets.

@spin0us
spin0us / gist:11376298
Created April 28, 2014 15:58
mMySQL : Convert all table from MyISAM to InnoDB
SELECT CONCAT('ALTER TABLE ',table_schema,'.',table_name,' ENGINE=InnoDB;')
FROM information_schema.tables
WHERE table_schema NOT IN ('mysql','test','performance_schema','information_schema')
AND ENGINE='MyISAM'