Interested to Buy Any Domain ? << Click Here >> for more details...
What is diff b/w MYISAM and INNODB storage engine. and also
define the benifits and drawbacks of both storage engine
- 1 Answers
- 3766 Views
- I also Faced
- E-Mail Answers
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 |
What is the difference between truncate and delete?
How do you shutdown a mysql database?
How do you name a table?
How can we find the number of rows in a table using MySQL?
How to calculate expressions with sql statements?
What is the hostname for mysql database?
What is the limit of mysql database?
Suppose you have to collect the first name, middle name and the last name of students from the below table. But, you observe that there few missing values either in the first name, middle name and the last name columns. How will you return the first non-null values?
What are the functions used to encrypt and decrypt the data present in mysql?
Write a command to list all databases in mysql?
What are the 'mysql' command line options?
What do I do if I forgot my mysql root password?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
