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)) ?
- 7 Answers
- 18274 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / vikash shaw
Total 5 types of tables we can create in mysql
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.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What sized websites have you worked on in the past?
What is the difference between php 5 and php 7?
Is java is better than php?
What is the purpose of the '.myi' file extension? What do thes file contain?
What is PHP? Who is the father or inventor of PHP?
What are the characteristics of php?
What are the Advantages and Application Areas of PHP?
How to create and destroy cookies in php?
Write a program in php to check whether a number is prime or not?
What is php and its advantages?
Is php front end or back end?
Tell me what kind of things have you done on the social side?
What is move_uploaded_file in php?
Tell me how can we define a variable accessible in functions of a php script?
How to find a specific value in an array?
