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,100 points
29 views

1 answer to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
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
22 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
36 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
52 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
36 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,270 points
28 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,120 points
53 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,560 points
37 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
15 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
15 views

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.