What are the different table present in MYsql?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What does mysql_query return?

496


How do I completely remove mysql from windows?

447


What is a left join mysql?

470


What is the current version of mysql?

477


What language does mysql use?

430






What is offset limit?

484


Can I install mysql on mac?

520


How to calculate the difference between two dates?

480


What is dbms in mysql?

502


How can you change the password of a mysql user?

493


How to get data from mysql in php?

427


Can I use mysql for free?

476


How do you kill a long running query in mysql?

461


How to write optimized query in mysql?

532


Is sqlite faster than mysql?

489