oliverlundquist/alter-table.sql

Created July 28, 2016 08:37

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/oliverlundquist/f8d7725d6a3f719e967272736ef96505.js"></script>
Save oliverlundquist/f8d7725d6a3f719e967272736ef96505 to your computer and use it in GitHub Desktop.

Download ZIP

Alter Table

Raw

alter-table.sql

MYSQL_PWD=root mysql --host="0.0.0.0" --user="root" --batch --skip-column-names --execute "SELECT CONCAT('ALTER TABLE ' , TABLE_SCHEMA , '.' , TABLE_NAME , ' ENGINE = InnoDB;') FROM INFORMATION_SCHEMA.TABLES WHERE ENGINE = 'MyISAM' AND TABLE_NAME LIKE '%_mystore_no_%'" | MYSQL_PWD=root mysql --force --host="0.0.0.0" --user="root"

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