Snippets
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
| 2895 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';
"Starting from scratch" is seductive but disease ridden
-Pithy Advice for Programmers