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
- 3745 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 Inner Joints and Outer Joints ? What is right outer joints,left outer joints,right inner joints , left inner joints ,
How do I download mysql on my laptop?
How to update info already in a table and delete a row(s) from a table.
What is mysql server?
how to take mysql database backup?
What is the purpose of using a heap table?
Give string types available for column?
Which one of the following is the correct way to select all columns and all rows from "vtable"? Choice 1 SELECT FROM vtable SELF JOIN vtable Choice 2 SELECT ALL COLUMNS FROM vtable WHERE ALL ROWS = * Choice 3 SELECT EVERYTHING FROM vtable Choice 4 SELECT vtable.* WHERE vtable = vtable Choice 5 SELECT * FROM vtable WHERE 1 = 1
What is the maximum size of mysql database?
How can you retrieve a portion of any column value by using a select query?
How can you import tables from a sql file into a database by using the mysql client?
How do I insert multiple rows in a table?
-
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)
