database | Blokeish.com

25.08.11

Comments

One Comment

Tell Friends

MySql Mass Convertion of Database Table’s Storage Engines from Other Types to InnoDB

A Few months back I had to convert moodle LMS database storage engine from MyISAM to InnoDB. Moodle has some 200+ databases and to manually convert each table takes an awful lot of time. My friend who was responsible for Read the entire post…

04.08.11

Comments

4 Comments

Tell Friends

Joining Three or More Tables in SQL With MySql (Nested Joins)

Joining three or more database tables seems a bit tricky. But once you know how to join three tables you can literally join any number of database tables. For the purpose of this tutorial I have four tables named Table1 Read the entire post…