hi all,
I am confused with the different type of databases mySql provides.What is exactly the difference between them?is there a reason why i should use one over the other?
i actually just starting delving into this stuff myself. I made the switch to InnoDB for my current projects database when I discovered foreign constraints, something innodb supports while myisam doesnt. For better referential integrity, go with innodb over myisam and learn constraints.