Different tables present in MySQL

Question

Hi friends I want to know that what are the different tables present in MySQL which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2)ename varchar(10)) ? Thanks

Satyapriya Nayak · Answer

Hi Mike There are two storage engine available in mysql database they are 1.MyISAM 2.InnoDB MyISAM is the default storage engine.Each MyISAM table is stored on disk in three files. The files have names that begin with the table name and have an extension to indicate the file type. An .frm file stores the table format. The data file has an .MYD (MYData) extension. The index file has an .MYI (MYIndex) extension. InnoDB is a transaction-safe (ACID compliant) storage engine for MySQL that has commit rollback and crash-recovery capabilities to protect user data. InnoDB row-level locking (without escalation to coarser granularity locks) and Oracle-style consistent nonlocking reads increase multi-user concurrency and performance The big difference between MySQL Table Type MyISAM and InnoDB is that InnoDB supports transaction InnoDB supports some newer features: Transactions row-level locking foreign keys InnoDB is for high volume high performance Table is created of default type - MyISAM Thanks