MYSQL

MYSQL

MySQL is an open-source relational database management system (RDBMS). It is the most popular database nowadays.
Many popular applications, companies, and websites like Youtube, Facebook, Twitter Github are using this database. MySQL is developed, distributed, and supported by Oracle Corporation.
The data in the MYSQL Database is stored in the form of tables, where each table consists of rows and columns. A column defines a particular entity of a table whereas a row defines data.
MYSQL is a database that runs on a webserver.
MYSQL can be used for small, medium, and large-scale applications.
To connect to a database we need to provide the hostname where the database is hosted, the username, and password of the user who can access that database.

Key terms in database:

Database - A database is a collection of tables.
Table - A table in a database contains rows and columns that handle data in it.
Column - One column contains data of the same kind within the table.
Row - A row is a group of related data and represents the data which table defines.
Redundancy - Storing data twice, redundantly to make the system faster.
Primary Key - A primary key is a unique item in the table. A key value cannot occur twice in one table. With a key, you can only find a single row.
Foreign Key - A foreign key is used to link two tables by a condition.
Compound Key - A compound key is a key that consists of multiple columns because one column is not sufficiently unique.
Index - An index in a database resembles an index that can be searched.

MySQL is becoming so popular because of the following reasons:

MySQL is an open-source database, so you don't have to pay to use it.
MySQL is a very effective program that can handle a large set of functionality of the most expensive and strong database packages.
MySQL is customizable because it is an open-source database, and the open-source GPL license facilitates programmers to modify the SQL software according to their specific environment.
MySQL is faster than other databases, so it can work well even with large data collections.
MySQL sustains many operating systems with many languages like PHP, PERL, C, C++, ASP, JAVA, etc.
MySQL uses a standard form of the well-known SQL data language.
MySQL is very friendly with PHP, the most widespread and robust language for web development.
MySQL supports large databases, up to 50 million rows or more in a table. The default file size limit for a table is 4GB, but you can increase this by configuring within the system to store more data when required.

For more details about MySQL and documentation click here