Default type is MyISAM Generates 3 files 1.frm 2.Myd 3.Myi fo

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

Question Posted / umesh ms analytica-india

7 Answers
19438 Views
HCL, I also Faced
E-Mail Answers

Answer Posted / umesh ms analytica-india

Default type is MyISAM

Generates 3 files

1.frm
2.Myd
3.Myi

format files

Is This Answer Correct ?

24 Yes

5 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is a base url?

892

Can you use both this () and super () in a constructor?

943

What is the difference between null and empty?

964

What is the meaning of php?

891

What is framework? How it works? What is advantage?

907

List few sensible functions in PHP?

937

Is php a middleware?

911

What is polymorphism in oop php?

941

Can I learn php in a month?

995

Is it easy to learn wordpress?

921

Why do we use interface in php?

918

Write a program to find no of days between two dates in php?

935

What is the difference between for and foreach in php?

973

Tell me what are the __construct() and __destruct() methods in a php class?

947

How to strip whitespace (or other characters) from the beginning and end of a string?

831