Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 19919 Views
- HCL, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / sunil kumar
There are fives tables in MySQL
1 MyISAM
2 Heap
3 Merge
4 INNODB
5 ISAM
When we create a table in MySQL, MyISAM is created
| Is This Answer Correct ? | 11 Yes | 3 No |
Answer / tariq
There are basically two types of tablein MYSQL:
1. Transaction safe
2. Non transaction safe
Transaction safe consist of InnoDB, BDB
Non transaction table includes ISAM, MYISAM, MERGE, HEAP
| Is This Answer Correct ? | 7 Yes | 3 No |
Answer / 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 |
Answer / albert
There are basically two types of tablein MYSQL:
1. Transaction safe
2. Non transaction safe
/**
*Transaction safe consist of InnoDB, BDB
*Non transaction table includes ISAM, MYISAM, MERGE, HEAP
*/
Default type is MyISAM
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / mani
5 type of table is there
1.MyISAM
2.Heap
3.Merge
4.InnoDB
5.BDB
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / sailesh jaiswal (lamp institut
MySQL supports 2 types of tables.
1. Transaction Safe Table (TST)
2. Non-Transaction Safe Table (NTST)
1. Transaction Safe Table: This type is safer compared to
NTST. Here transactions are temporary. We have ROLLBACK &
COMMIT commands available. Supports Foreign Key, Locking.
Used for More WRITES & Less READS.
Storage engines INNODB, BDB creates TSTs
2. NTST: Here transactions are permanent. No COMMIT, No
ROLLBACK. Partial Support for Foreign Key, Locking. Used for
More READS & Less WRITE.
Storage engines MyISAM, HEAP creates NTSTs.
| Is This Answer Correct ? | 2 Yes | 1 No |
How to install PHP with --mcrypt and --mhash?
What is indexing how many types?
3 Answers DLF, Infosys, Net Solution, Vcare,
Which function is used in php to check the data type of any variable?
my english is not too good then what we apply for a php programer post
Explain what does the unlink() function means?
What is PEAR?
What does pear stand for?
Write a program using while loop in php?
What is put method in php?
How many ways are there for passing variables between pages in PHP and what are they ?
What is abstraction php?
What is the difference between substr() and strstr()?
PHP 
