what are the main differences between MyISAM and InnoDB
table storage structures ?
what are the advantages and disadvantages in usage of these ?

Answer Posted / chalbal jha

MyIsam provide full text search which is not supported by
Innodb

Is This Answer Correct ?    21 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I show all mysql databases?

503


How can we encrypt and decrypt a data presented in a table using mysql?

545


What is the difference between the LIKE and REGEXP operators?

529


What are the critical issues you have resolved in your company

1751


how to add a new column to an existing table?

557






How does mysql encrypt passwords?

476


What could be the reason that the mysql statement 'select avg (salary) from emp' generates an inaccurate output?

491


What is the maximum size of table in mysql?

552


What is longblob?

535


Which command is used to view the content of the table in mysql?

489


Does mysql use t sql?

571


What language is mysql written in?

493


How to present a past time in hours, minutes and seconds?

545


Is mysql a free database?

479


explain GROUPBY & HAVING clause with examples.

1825