Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

What is the best table type in MySQL ?

user-image
Question added by SHERIF SAKR , Senior Application developer , 1stcentury
Date Posted: 2014/05/22
Julfkar  Moh Umar
by Julfkar Moh Umar , Sr. Software Engineer , Aakash Edutech Private Limited

The InnoDB and Berkley DB (BDB) database engines are direct products of the technology that makes MySQL so flexible, the MySQL++ API. Almost every challenge you're likely to face when using MySQL stems directly from the fact that the ISAM and MyISAM database engines aren't transactional and lack foreign-key support. Although much slower than the ISAM and MyISAM engines, InnoDB and BDB include the transactional and foreign-key support missing from the former two choices. As such, if your design requires either or both of these features, you are actually compelled to use one of these two choices.

karan sandhu
by karan sandhu , Senior Software Developer + Technical Support , NetSoftLab

bro you can use Innodb and MyISAM engines

More Questions Like This

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.