What is diff b/w MYISAM and INNODB storage engine. and also
define the benifits and drawbacks of both storage engine



What is diff b/w MYISAM and INNODB storage engine. and also define the benifits and drawbacks of bo..

Answer / rajanikanth

1)MYISAM does not support the foreign key constraint and
transaction but InnoDB support it.

2)MYISAM is faster then the InnoDB but in case of perforing
the count operation it takes more time then the InnoDB.

3) MYISAM occupies less memory sapce for tables rather than
InnoDB tables.

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More MySQL Interview Questions

when i declare date data type in sql ,i inserted the date 22-10-2012,but my result is in different date 1894-07-11 any one pls help me what's wrong in my query Create table orders(od_id int,od_name varchar(10),od_date date) insert into orders values(1,'sai',22-10-2012) and any one pls suggest what i can learn for 3 years real time experenice in sql because i am looking for database field

1 Answers  


Is mysql a dbms?

0 Answers  


How to convert numeric values to character strings?

0 Answers  


What are mysql functions?

0 Answers  


How many services is running in sql server?

3 Answers   ACC, V2 Solutions,






What are the difference between now and current_date in mysql?

1 Answers  


What is mysqlcommand?

0 Answers  


Explain the difference between mysql and mysql interfaces in php?

0 Answers  


How do you start and stop MySQL on Windows?

3 Answers  


What is processlist in mysql?

0 Answers  


What is difference between mysql_connect and mysql_pconnect?

0 Answers  


I want to insert userid of a customer,order time,etc in a table called ordermaster with orderid as primary key.Same time the product codes and required quantities (a1,2 and a2 4 and so on)inserted in another table orderdetails with same orderid reference.How the code will be in JSP using MySQL?

0 Answers  


Categories