Forum : What are the different table present in MYsql?
Brief description  about Online courses   join in Online courses
View Arun  Desai 's Profile

What are the different table present in MYsql?

What are the different table present in MYsql??
Asked by Arun Desai | Mar 19, 2010 |  Reply now
Replies (1)
View teacher siliconindia 's Profile
Hi Arun,
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
Mar 19, 2010