Never been to CodeSnippets before?

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 (or not, you can keep them private!)

Bulk convert InnoDB tables to MyISAM (See related posts)

// produces some handy ALTER statements
// I think there's a way to this w/ mysqladmin but I couldn't find it.

SELECT CONCAT('ALTER TABLE ',table_schema,'.',table_name,' engine=MyISAM;') FROM information_schema.tables WHERE engine = 'InnoDB';
to mysql sql innodb myisam convert by jamiew on Wed Apr 02 06:34:58 +0000 2008

Comments on this post

jamiew posts on Apr 29, 2008 at 18:33
Testing comments on new "CodeSnippets"!

You need to create an account or log in to post comments to this site.


Related Posts