Home >> MySql >> Explain advantages of InnoDB over MYISAM in MySql

Explain advantages of InnoDB over MYISAM in MySql

1-InnoDB better or automatically crash recovery but MyISAM does not support crash recovery.

2-InnoDB has row level locking for inserting and updating but MYISAM support full table level locking.

3-InnoDB has transactions but MyISAM does not.

4-InnoDB has foreign keys and relationship contraints but MyISAM does not.

Post Your Comment

Next Questions
What are various DDL commands
What are various DML commands
What are various DCL commands
What is the default port of server
What are the differences between MyISAM static and MyISAM dynamic
What is purpose of the NVL function
Latest version
How can find current date function
What is HEAP table
What is CSV table
What is MERGE table
What is federated table
What are data types
Numeric data types
Floating data types
Date and Time data types
String data types
Enum data types
SET data types
Difference between varchar and char
Difference between Tinyint and smallint
Difference between enum and set
Difference between signed and unsigned
What is key
What is super key

Copyright ©2022 coderraj.com. All Rights Reserved.