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 an index? How can an index be declared in mysql?
What is longblob?
Can mysql scale horizontally?
How do you start MySQL on Linux?
What is the difference between the DELETE TABLE and TRUNCATE TABLE commands in MySQL?
Can you save your connection settings to a conf file?
What is the latest version of mysql?
What are numeric data types?
What is mysqli_free_result?
What is the data type for image?
How do I update a variable in mysql?
How can you retrieve a particular number of records from a table?