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
- 19713 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 read the entire file into a single string?
How arrays are passed through arguments?
How to convert a string to lowercase in php?
What does $globals means?
What does $globals mean?
I created a new joomla module for administrator. when am going to install this, it is going "joomla/modules" path. but, i want to install this in the "joomla/administration/modules" path.
Can we run php in apache tomcat?
Can the value of a constant change during the script's execution?
How can we check the value of a given variable is a number?
Name some of the functions in php.
What's the difference between using mysql_ functions and pdo?
What is needed to be able to use image function?
PHP 
