What are the different table present in MYsql?
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 to set the time zone for MySQL to particular country time?
What are the different tables present in MySQL?
What is a join? Explain the different types of mysql joins.
Does mysql use sql?
how to Return total number of rows.
What is relational database in mysql?
Where does mysql store data?
How can you count the total number of records of any table?
How to calculate the difference between two dates?
What is strict mode in mysql?
What is action query?
What is blob storage?
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)