Discussion board
What are the different table present in MYsql?
By Arun Desai
What are the different table present in MYsql??
Reply
Post   Reset
Teacher SiliconIndia replied to Arun Desai Friday, March 19, 2010
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