What are the features of MySQL

+1 vote
Hii!

Can someone tell me the features of MySQL?
Dec 12, 2018 in Database by Sahiti
• 6,370 points
5,304 views

1 answer to this question.

+1 vote

The features of MySQL are as follows:

  • Ease of Management – The software very easily gets downloaded and also uses an event scheduler to schedule the tasks automatically.
  • Robust Transactional Support – Holds the ACID (Atomicity, Consistency, Isolation, Durability) property, and also allows distributed multi-version support. 
  • Comprehensive Application Development – MySQL has plugin libraries to embed the database into any application. It also supports stored procedures, triggers, functions, views and many more for application development. 
  • High Performance – Provides fast load utilities with distinct memory caches and table index partitioning.
  • Low Total Cost Of Ownership – This reduces licensing costs and hardware expenditures.
  • Open Source & 24 * 7 Support –  This RDBMS can be used on any platform and offers 24*7 support for open source and enterprise edition.
  • Secure Data Protection – MySQL supports powerful mechanisms to ensure that only authorized users have access to the databases.
  • High Availability – MySQL can run high-speed master/slave replication configurations and it offers cluster servers.
  • Scalability & Flexibility – With MySQL you can run deeply embedded applications and create data warehouses holding a humongous amount of data.
answered Dec 12, 2018 by DataKing99
• 8,240 points

Related Questions In Database

0 votes
2 answers

What are the ways to get the count of records in a table

With the help of the SQL count ...READ MORE

answered Aug 20, 2020 in Database by Okugbe
• 280 points
3,563 views
0 votes
1 answer

What are the different types of index?

There are three types of index namely: Unique ...READ MORE

answered Oct 17, 2018 in Database by Sahiti
• 6,370 points
7,903 views
0 votes
1 answer

What are the advantages of SQL?

Simple SQL queries can be used to ...READ MORE

answered Nov 8, 2018 in Database by DataKing99
• 8,240 points
5,764 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 Sahiti
• 6,370 points
5,475 views
0 votes
1 answer

Why is not preferable to use mysql_* functions in PHP?

The reasons are as follows: The MySQL extension: Does ...READ MORE

answered Sep 7, 2018 in Database by DataKing99
• 8,240 points
895 views
0 votes
1 answer

Find values in a comma separated string in a MySQL query

You can add commas to the left and ...READ MORE

answered Sep 10, 2018 in Database by Sahiti
• 6,370 points
12,623 views
0 votes
1 answer

How to do a batch insert in MySQL

You can try out the following query: INSERT ...READ MORE

answered Sep 10, 2018 in Database by Sahiti
• 6,370 points
2,024 views
0 votes
1 answer
0 votes
1 answer

What are the ways of Data Import and Export in MySQL Workbench?

There are majorly three ways to export ...READ MORE

answered Dec 14, 2018 in Database by DataKing99
• 8,240 points
2,022 views
0 votes
1 answer

What are the various levels of constraints

Constraints are the representation of a column ...READ MORE

answered Oct 18, 2018 in Database by DataKing99
• 8,240 points
2,546 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP