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"!
bevisaxel posts on May 31, 2010 at 10:32
This post is very informative and according to the requirement of the customers. No only this, site is also user friendly and informative. Looking for the new ideas about the following terms. I hope you will guide me in this aspect!

-------------------
000-112 ! 000-141 ! 000-150 ! 000-175

seo posts on Jul 24, 2010 at 13:50
www.advesgroup.com

www.advesreklam.com

sevismesahnesi.tk

seksseyret.com

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


Related Posts