Types of tables in MySQL

0 votes
Hi!!

What are the different types of tables in MySQL?
Aug 21, 2018 in Database by DataKing99
• 8,130 points
89 views

1 answer to this question.

0 votes

MyISAM is the default table that is based on the sequential access method.

  • HEAP is the table that is used for fast data access but data will be lost if the table or system crashes. 
  • InoDB is the table that supports transactions using the COMMIT and ROLL BACK commands.
  • BDB can support transactions similar to InoDB but the execution is slower.
answered Aug 21, 2018 by CodingByHeart77
• 3,680 points

Related Questions In Database

0 votes
2 answers

Types of relationships in Database

There are 3 types of relationships in ...READ MORE

answered Aug 16, 2018 in Database by zombie
• 3,690 points
36 views
0 votes
1 answer

What are the different types of keys used in the database?

There are mainly 5 types of Keys, ...READ MORE

answered Nov 19, 2018 in Database by darklord
• 6,140 points
74 views
0 votes
1 answer

What is the syntax of USE statement in MySQL?

The USE statement is used to mention ...READ MORE

answered Nov 27, 2018 in Database by darklord
• 6,140 points
74 views
0 votes
1 answer

what is the syntax of OR statement in MySQL?

The OR operator displays those records which ...READ MORE

answered Nov 30, 2018 in Database by darklord
• 6,140 points
45 views
0 votes
1 answer

Want a command to be executed in Salt only if a directory is empty

You should consider using this inside your ...READ MORE

answered Jun 12, 2018 in DevOps Tools by Damon Salvatore
• 5,510 points
38 views
0 votes
1 answer

Creating A New MySQL User In Amazon RDS Environment

AWS RDS security groups documentation (a common ...READ MORE

answered Jul 18, 2018 in AWS by Priyaj
• 56,520 points
146 views
0 votes
1 answer

Using conditional to execute a command in salt

You can use unless inside your state ...READ MORE

answered Jul 23, 2018 in Other DevOps Questions by DareDev
• 6,810 points
75 views
0 votes
1 answer

TRIGGERS used in MySQL tables

The following TRIGGERS are allowed in MySQL:  BEFORE ...READ MORE

answered Aug 21, 2018 in Database by CodingByHeart77
• 3,680 points
24 views
+1 vote
1 answer

Cursor and Its Types

The cursor is a temporary work area ...READ MORE

answered Aug 9, 2018 in Database by CodingByHeart77
• 3,680 points
23 views