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

Answer Posted / sharath bit

it supports online backups

Is This Answer Correct ?    9 Yes 15 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is pragma serially_reusable and why is it used?

469


What is mysql database used for?

480


How to enter Characters as HEX Numbers?

545


What are the 'mysql' command line options?

499


List the different types of normalization?

526






What is offset limit?

482


Explain csv tables.

549


Table - Products has number of products as below Productid ProductName 1 iPhone 2 iPad 3 BlackBerry Table - SalesPersonProduct has the below records Salespersonid productid S1 1 S1 2 S1 3 S2 1 S3 2 Write a SQL query that returns the total number of sold products

2410


What are triggers mysql?

478


What is auto increment in mysql?

493


How many queries can mysql handle?

491


How to insert dynamic values in mysql using php?

533


How can you calculate the sum of any column of a table?

503


Write a query to fetch common records between two tables using mysql?

530


How do I truncate all tables in mysql?

479