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
Loading
Satyapriya NayakPosted Dec 31, 2011, 6:11 AM
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