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 |
What is ntext?
What is difference between mysqli and pdo?
How do I quit mysql?
List some mysql advantages and disadvantages?
Why to use char instead of varchar in the database?
How to insert html code into mysql database using php?
How to store values to array from mysql database in php?
What are stored procedures and functions?
How do I select a database in mysql?
What are the 'mysql' command line arguments?
change column name and make a unique column so we get no dupes.
Explain advantages of MyISAM over InnoDB?
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)