Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
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'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.