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 can you declare a constant variable in php?
Why post method is used in php?
Is it worth learning php in 2019?
How to support multiple-page forms?
Tell me what kind of things have you done on the social side?
Which function can be used to delete a file?
Tell me how can we get the error when there is a problem to upload a file?
What should be the length of variable for SHA256?
What is the difference between myisam and innodb?
Tell me how to find the position of the first occurrence of a substring in a string?
Where php language is used?
What is a controller in php?
What is the difference between static and dynamic websites?
How is it possible to propagate a session id?
Why do you need to filter out empty files?