What are the different table present in MYsql?
- 3 Answers
- 11901 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / subrat
MyISAM: This is default. Based on Indexed Sequntial Access
Method. The above SQL will create a MyISA table.
ISAM : same
HEAP : Fast data access, but will loose data if there is a
crash. Cannot have BLOB, TEXT & AUTO INCRIMENT fields
BDB : Supports Transactions using COMMIT & ROLLBACK. Slower
that others.
InoDB : same as BDB
| Is This Answer Correct ? | 13 Yes | 1 No |
Answer / rajesh kumar
BDB supports transaction and page level locking. InnoDB
Supports Foreign Keys, Row level locking & transaction .
| Is This Answer Correct ? | 3 Yes | 0 No |
How many groups of data types?
In how many ways we can retrieve data in the result set of mysql using php?
What is 'mysqldump'?
How do you create a new database in mysql?
What are the 'mysql' command line arguments?
How to check if a record exists in a mysql database php?
How to write after insert event update trigger on the same table in mysql?
What are the nonstandard string types?
What is DDL in MySQL?
How can you find out the version of the installed mysql?
How many columns can you create for an index?
What is mvcc in mysql?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
