What Are The Different Table Present In Mysql?

1.	What Are The Different Table Present In Mysql?
Answer» 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 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

Answer»

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

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

Discussion