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)) ?
Answer Posted / 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 |
Post New Answer View All Answers
How many types of session are there?
What is the difference between unset and unlink?
When is a conditional statement ended with an endif?
What is inheritance in php?
What is a http session?
What is different between software and app
What sized websites have you worked on in the past?
How to store the uploaded file to the final location?
What are arguments in php?
Why is php used?
What are variables in research examples?
What is the use of curl()?
Tell me how to set a page as a home page in a php based site?
What is interface? Why it is used?
How to connect to a url in php?