Skip to content

Instantly share code, notes, and snippets.

@sergeliatko

sergeliatko/ater_tables_innodb.sql

Created November 22, 2017 16:56
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save sergeliatko/beec8e2514dc34549e0ece991037cef2 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save sergeliatko/beec8e2514dc34549e0ece991037cef2 to your computer and use it in GitHub Desktop.
Download ZIP
Generates SQL to alter all tables from a database (DBName) to InnoDB engine.
Raw
ater_tables_innodb.sql
SELECT CONCAT( "ALTER TABLE ", table_name, " ENGINE=InnoDB;" )
FROM information_schema.tables
WHERE engine = 'MyISAM'
AND table_schema = 'DBName';
@sergeliatko
Copy link
Copy Markdown
Author

sergeliatko commented Nov 22, 2017

Just replace DBName with the name of your database

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment