Logo
×

MySQL Features

Features of MySQL

  • MySQL is a relational database management system (RDBMS): It is a collection of many programs and makes relations with many other programs.
  • Easy to use MySQL database: MySQL is very easy to use and user-friendly hence easily install and manipulate.
  • MySQL database is fully secure: MySQL has a very strong data security layer to protect sensitive data like password, sensitive information, etc. from intruders. Passwords are encrypted in the MySQL database.
  • MySQL follows a client and server architecture: MySQL works on client-server architecture. There is a database server (MySQL) and arbitrarily many clients (application programs), which communicate with the server by query data, save data, changes in data, etc.
  • Open source and free do download: MySQL is free to download means there is no cost to pay for downloading. You can download it from its official website.
  • MySQL is scalable: MySQL can handle generally any amount of data, up as much as 50 million rows or more. The default size limit is about 4GB. You can increase this limit up to the theoretical limit of 8TB of data.
  • MySQL database is compatible with many operating systems: MySQL compatible to run with many operating systems, like Windows, Linux, many verities of UNIX Such as Sun* Solaris*, AIX, and DEC* UNIX Novell Netware.
  • MySQL allows roll-back: MySQL allows the transaction to roll back, commit and crash recovery.
  • MySQL is faster: MySQL is faster, and more reliable and cheaper because of its unique storage system.
  • MySQL is also highly flexible: MySQL is embedded with a large number of applications which makes MySQL very flexible.
  • MySQL has high productivity: MySQL delivers developers high productivity because MySQL triggers store procedures and views.

Disadvantage or Drawback of MySQL

Few disadvantages of MySQL are as follow:
  • MySQL does not support large database size much effectively.
  • MySQL does not handle translation much effectively and it is prone to data corruption.
  • MySQL does not support SQL check constraints.
  • MySQL version less than 5.0 does not support ROLE, COMMIT and Stored Procedure.
  • MySQL does not have a good developing and debugging tool compared to paid databases.

Related Topics

MySQL MONTHNAME() function

In this context, we will learn how we can use the MySQL MONTHNAME() Function with proper syntax and good examples. Introduction of MySQL MONTHNAME() function In MySQL the MONTHNAME() Function is used...

3 minutes read.

MySQL ASIN() Function

In this context we will learn how we can use the ASIN() function in MySQL with proper syntax and good example. Introduction of MySQL ASIN() function The arc sine value of a...

2 minutes read.

MySQL Union

MySQL contains the same categories of data in a different table. Sometimes, you require multiple tables to collect data together. MySQL union is a function to combine two table's data...

5 minutes read.

MySQL FORMAT() function

In this context, we will learn how we can use the MySQL FORMAT() function with proper syntax and good examples. Introduction of MySQL FORMAT() function This function in MySQL helps to format...

2 minutes read.

MySQL Invisible Index

Invisible Index MySQL index decides an option to the availability of the index for the query optimizer. This index shows the visible and invisible options to displays the index column in...

3 minutes read.

MySQL SOUNDEX() function

In this context, we will learn how we can use the MySQL SOUNDEX() function with proper syntax and good examples. Introduction of MySQL SOUNDEX() function SOUNDEX() function in MySQL is used to...

3 minutes read.

MySQL FIND_IN_SET() function

In this context, we will learn how we can use the MySQL MOD() function with proper syntax and good examples. Introduction of MySQL MOD() function MySQL provides a built-in string function called...

4 minutes read.

MySQL FIELD() function

In this context, we will learn how we can use the MySQL FIELD() function with proper syntax and good examples. Introduction of MySQL FIELD() function The index position of a mentioned value...

3 minutes read.

MySQL Advance function

The advance function operates numerical values, string values, and data types.  The advance function converts, displays, and compares given values as per requirement. Here, you find out database, table, and...

4 minutes read.

MySQL AVG function

This function works on numerical data type values. The average function shows the average value of the data set. If an average function returns a null value, then the row...

5 minutes read.

MySQL variable

The MySQL variable is essential for storing data in the table. The variable declares data with a specific name or label to avoid confusion. This data label is used in...

6 minutes read.

MySQL Date and Time function

The date function displays day, year, month, time, and current date. It shows the date and time as per the requirement of the applications. The data either store on the...

8 minutes read.

MySQL Tutorial

In this tutorial, you will get information about the MySQL management system. This tutorial will cover the basic and advanced level MySQL concepts with examples that will help you become...

5 minutes read.

MySQL INSTR() Function

In this context, we will learn how we can use the MySQL INSTR() function with proper syntax and good examples. Introduction of MySQL INSTR() function This function in MySQL returns the location...

4 minutes read.

MySQL LIKE() function

In this context, we will learn how we can use the MySQL LIKE() function with proper syntax and good examples. Introduction of MySQL LIKE() function The LIKE function is a logical function...

4 minutes read.

MySQL Aggregate function

The aggregation function works on the multiple values and returns single value output.  It makes the advanced and complex operation simple. The summation (SUM), MAX, AVG, MIN, COUNT functions are...

5 minutes read.

MySQL View

Introduction MySQL View is a virtual table to create a clone of the base table. The View does not contain its values or data. MySQL View creates to connect more than...

12 minutes read.

MySQL NOW() function

In this context, we will learn how we can use the MySQL NOW() function with proper syntax and good examples. Introduction of MySQL NOW() function Basically, in MySQL, this function is used...

2 minutes read.

find_in_set() function in MySQL

This Function is used for finding the position of a particular string from the list of strings. For suppose if the specified string is repeated multiple times, then this functions...

4 minutes read.

MySQL Create index

An index creation helps to make a row of the table unique. The index operates and handles table data quickly. MySQL index requires NOT NULL column constraint. The index column...

2 minutes read.