myisam supports table level locking where as innoodb supports only row lev

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

Question Posted / dharma teja

Answer Posted / dharma teja

myisam supports table level locking where as innoodb
supports only row level locking when updated

Is This Answer Correct ?

32 Yes

10 No

Please Help Members By Posting Answers For Below Questions

What are date and time data types in mysql?

1026

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

975

How to show all records starting with the letters 'sonia' and the phone number '9876543210'

936

What is cursor in mysql?

898

What are the differences between mysql vs sql server?

1060

How to delete a trigger in mysql?

927

Will mysql remain free?

963

How to load a csv file into a table

1037

What is sql in mysql?

1035

How is myisam table stored?

964

How do I exit mysql?

925

How do I export mysql query results to excel?

971

Write a query to count the number of rows of a table in mysql.

937

How many columns can you create for an index?

954

How many ways to get the current time?

973