mySQL: Change table type - Generate an alter table statement to change table type from myisam to innodb.

Quick Search:

mySQL: Change table type

Jump to:

Snippet Name: Change table type

Description: Generate an alter table statement to change table type from myisam to innodb.

Comment: (none)

Language: MYSQL
Highlight Mode: MYSQL
Last Modified: March 01st, 2009

SELECT CONCAT('ALTER TABLE ', TABLE_SCHEMA, '.', TABLE_NAME, ' ENGINE=Innodb;')  
FROM information_schema.TABLES WHERE ENGINE = 'MYISAM';