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
- 19480 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 |
What are super global variables in php?
What is the use of Mbstring?
Do csrf tokens expire?
How many data types are there in php?
How a constant is defined in a php script?
What is PHP? Who is the father or inventor of PHP?
How to find the length of a string?
What is overloading in php?
How to remove leading and trailing spaces from user input values?
How to pass an argument to a function?
Is nan in javascript?
Define soundex()?
PHP 
