CoderZone.org

Category: >> mySQL >> Change table type Bookmark and Share

<< lastnext >>

Snippet Name: Change table type

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

Comment: (none)

Author: CoderZone
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';
 
There haven't been any comments added for this snippet yet. You may add one if you like.  Add a comment 
© coderzone.org | users online: 4