Snippets has posted 5883 posts at DZone. View Full User Profile
// 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';
DZone's 170th Refcard is an essential reference to Camel, an open-source, lightweight, integration library. This Refcard is authored by...