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

Answer Posted / vikas

MyISAM don't take more space comparision to the INNODB in mysql

Is This Answer Correct ?    6 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How many rows can a mysql table hold?

715


What is triggers and how it can be used in mysql?

741


Which is faster innodb or myisam?

752


How can you change the name of any existing table by using the sql statement?

786


How do I clear the screen in mysql?

770


Where is mysql data stored?

661


What are the different column comparison operators in mysql?

709


What is the difference between the primary and unique key in mysql?

714


What is the date format in mysql?

678


How to show table names with 'mysqlshow'?

773


What is the default port for mysql and how it can change?

799


Tell us something about heap tables?

760


Why to use char instead of varchar in the database?

829


What is blob and clob?

733


What is the difference between mysql_connect and mysqli_connect?

709