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
- 19668 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 |
Is php better than java?
Explain object-oriented methodology in php?
How to create reusable code in php?
What is the major php security hole? How to avoid?
What are php functions?
How can we increase the execution time of a PHP script?
12 Answers CyberBeoz, Photon, XTX,
Does strlen include null?
What is asort php?
Why php is used?
What is implode() in php?
Is php an api?
What is the difference between $message and $$message?
PHP 
