Monday, November 23, 2009

What are the different tables present in MySQL?

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))?

Total 5 types of tables we can create
1. MyISAM
2. Heap
3. Merge
4. INNO DB
5. ISAM
MyISAM is the default storage engine as of MySQL 3.23. When you fire the above
create query MySQL will create a MyISAM table.

No comments:

Post a Comment

I just got my #domain @BigRock. Get upto 25% off with my personalized coupon link Get upto 25% off