What type of database is mysql?

Mysql is a relational database management system. A relational database stores data in different tables instead of placing all data in a large warehouse, which increases speed and flexibility.

The operating environment of this article: Windows 7 system, Mysql version 5.7.14, Dell G3 computer.

What type of database is mysql?

MySQL is a relational database management system developed by the Swedish MySQL AB company and is a product of Oracle. MySQL is one of the most popular relational database management systems. In terms of WEB applications, MySQL is one of the best RDBMS (Relational Database Management System) application software.

MySQL is a relational database management system. A relational database stores data in different tables instead of placing all data in one large warehouse, which increases speed and flexibility.

The SQL language used by MySQL is the most commonly used standardized language for accessing databases. MySQL software adopts a dual licensing policy and is divided into community version and commercial version. Due to its small size, fast speed, low total cost of ownership, and especially the characteristics of open source, MySQL is generally chosen as the website database for the development of small and medium-sized websites.

So what is a database?

Database is a warehouse that organizes, stores and manages data according to data structure.

Each database has one or more different APIs for creating, accessing, managing, searching and copying saved data.

We can also store data in files, but reading and writing data in files is relatively slow.

So, now we use relational database management system (RDBMS) to store and manage large amounts of data. The so-called relational database is a database based on the relational model, which uses mathematical concepts and methods such as set algebra to process data in the database.

Characteristics of RDBMS (Relational Database Management System):

1. Data appears in the form of tables

2. Each row has various record names

3. Each column is the data field corresponding to the record name

4. Many rows and columns form a form

5. Several forms form a database

Recommended learning: "mysql video tutorial"

The above is the detailed content of What type of database is mysql?. For more information, please follow other related articles on the PHP Chinese website!