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 to create an array in php?
What is polymorphism in oop php?
How a constant is defined in a php script?
What is a composer in PHP?
Is a number php?
Is wordpress a php framework?
What does $this do in php?
How to initiate a session in php?
What is varchar mysql?
What is magic quotes?
What does $globals mean?
What is sorting php?
What is the use of count() function in php?
What is $_ request?
What are some new features introduced in php7?