25.08.11

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

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…