DZone Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world

Snippets has posted 5883 posts at DZone. View Full User Profile

Change Table Type

01.30.2009
| 3165 views |
  • submit to reddit
        // generate alter table statement to change table type
// from myisam to innodb

select CONCAT('ALTER TABLE ', TABLE_SCHEMA, '.', TABLE_NAME, ' ENGINE=Innodb;')  from information_schema.tables where ENGINE = 'MYISAM';