Skip to content

Instantly share code, notes, and snippets.

@royce002

royce002/gist:1894c65e44335d4bb3d069572178ad0b

Created July 31, 2017 17:00
Show Gist options
  • Save royce002/1894c65e44335d4bb3d069572178ad0b to your computer and use it in GitHub Desktop.
Save royce002/1894c65e44335d4bb3d069572178ad0b to your computer and use it in GitHub Desktop.
Download ZIP
MySql Script to Move To Inno
Raw
gistfile1.txt
SELECT CONCAT('ALTER TABLE ',TABLE_NAME,' ENGINE=InnoDB;')
FROM INFORMATION_SCHEMA.TABLES
WHERE ENGINE='MyISAM'
AND table_schema = 'mydatabase';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment