What are the different table present in MYsql?
- 3 Answers
- 12641 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 |
What is the difference between truncate and delete in mysql?
What is the query to display top 20 rows?
Which is better mysql or mssql?
How do you use auto increment?
What is delimiter in mysql?
How to include character strings in sql statements?
How do I start mysql in ubuntu?
What are the disadvantages of stored procedures?
What is the use of mysql workbench?
How do I show all mysql databases?
Write a query to select all teams that won either 1, 3, 5 or 7 games.
What is the usage of ENUMs in MySQL?
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
