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 define numeric 9(3) in db2 table without decimal point??
What does schema mean?
What is the difference Delete and Drop ?
How do you know if your mysql server is alive?
What is the command used to create a database using php and mysql?
How do you start MySQL on Linux?
How do I completely remove mysql from windows?
What is the difference between the LIKE and REGEXP operators?
What is the difference between a heap table and temporary table?
how to find missing numbers between two order numbers; and dates ?
Why is the basic difference between left join, right join and inner join?
How many rows we can insert in a mysql table?
Oracle (3253)
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)