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)) ?
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 is the main difference between php 4 and php 5?
Which function Returns the time of sunrise for a given day / location in PHP.
Explain what does the expression exception::__tostring means?
What is difference between compile time and run time polymorphism?
Does php use html?
Explain how does one prevent the following warning ‘warning: cannot modify header information – headers already sent' and why does it occur in the first place?
Which variable declarations within a class is invalid in php?
Does php have multiple inheritance?
How is it possible to set an infinite execution time for php script?
Explain some of the php string functions?
Tell me what is the difference between get and post?
How many types of php frameworks are there?
Give the case where we can use get and we can use post methods?
Explain how can we execute a php script using command line?
Explain php split() function.