What is diff b/w MYISAM and INNODB storage engine. and also
define the benifits and drawbacks of both storage engine
Answer Posted / 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 View All Answers
Which statement is used in a select query for partial matching?
What is a join? Explain the different types of mysql joins.
Is mysql connect deprecated?
What are the steps involved in query processing?
How do I start mysql manually?
What language does mysql use?
How does limit work in mysql?
What is row level locking in mysql?
can you tell how can you display the maximum salary in sql? : Mysql dba
I've looked but can't find a MySQL equivalent for MS SQL's xp_cmdshell. I have 7z files that I want to unzip and load into MySQL. I'm trying to write a sp to do the unzip, but I can't find a way to do that. Can anyone provide an example of a similar process in Windows? TIA.
how to dump all databases for backup. Backup file is sql commands to recreate all db's.
What is mysql aggregate functions? Explain
what is the procedure to configure the application of mysql?
How you can create a trigger in mysql?
Why do we write stored procedures?