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
What is include in php?
Are php short tags acceptable to use?
What is a php certification?
What is difference between strstr() and stristr()?
What are getters and setters php?
How to set a page as a home page in a php based site?
Should I learn php before wordpress?
Is php open source?
Tell me what library is used for pdf in php?
Is salary fixed or variable cost?
Is it easy to learn php?
I am trying to assign a variable the value of 0123, but it keeps coming up with a different number, what is the problem?
What is the use of pear in php?
What is session management php?
What is php artisan serve?