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
- 18271 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 |
Give small demo of writting OOP in PHP-mysql.
What is default session time and path in PHP. How to change it?
How do you compare strings in java?
Which operator is used to combine string values in php?
What is the best way to test the strpos() return value in php?
What is the capacity of mysql database?
Tell us how to set cookies in php?
What does $_cookie means?
What is the super method?
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)) ?
What are the different methods of passing data or information between two calls of a web page? What are the advantages/disadvantages of these methods?
Tell me how do I escape data before storing it into the database?
PHP 
