what is the difference between MyIsam and InnoDb engine?
Answer Posted / madhuri
1) MYISAM is faster then the InnoDB but in case of perforing
the count operation it takes more time then the InnoDB.
2)MYISAM does not support the foreign key constraint and
transaction but InnoDB support it.
3)Upto Mysql 5.0 MyIsam is the default engine and from
Mysql 5.1 Innodb is the default engine.
4)MyIsam supports table level lock and where as Innodb
supports row level locking.
Thanks.,
Madhuri.
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is mysql root?
Is mysql running ubuntu?
What is the data type for file in mysql?
What is sqlyog?
What is procedures in mysql?
Is mysql relational database?
What is a mysql server?
How do I uninstall mysql connector?
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
What are the functions in mysql?
Describe mysql transaction properties.
How do we use % when performing a search query?
How do you rename a table?
What is normalization and list the different types of normalization?
How can you import tables from a sql file into a database by using the mysql client?