What does mysql database do

MySQL is a relational database management system developed by Swedish company MySQL AB and is a product of Oracle. MySQL is the most popular relational database management system

In terms of web applications, MySQL is one of the best RDBMS (Relational Database Management System) application software.

one.

MySQL is a relational database management system that stores data in different tables instead of putting all the data in one large warehouse, which increases the speed.

And improved flexibility.

The SQL language used by MySQL is the most commonly used standardized language for accessing databases. MySQL software adopts a dual licensing policy, divided into community edition and commercial edition.

Small, fast, low total cost of ownership, and especially open source, the development of small and medium-sized websites generally choose MySQL as the website database.

Knowledge point expansion:

The development history of databases can be divided into several stages

Manual management stage

File system stage: data access is difficult, concurrency control is difficult to implement, and data security is difficult to ensure

Data management system stage

Of course, these stages are self-explanatory, if you want to learn more, please search for relevant keywords

When learning MySQL, you may come across the following terms:

Database (DB)

A database is a warehouse that organizes, stores and manages data according to data structures.

The database provides many functions that can be defined through SQL statements to operate data

【DataBase Management System】DataBase Management System (DBMS)

Large-scale software for operating and managing databases, used to create, use and maintain databases

[Relational database]

Relational databases use tables to store data and use the relationships between tables to process data, which also provides guarantees for data security, integrity, concurrency control, and data recovery.

Common database service software: Oracle, MySQL (Oracle); SQL Server, Access (Microsoft)

[Terms of relational database]

Relationship: A two-dimensional table. Each relationship must have a relationship name, also known as the table name.

Field/Attribute: A column in a two-dimensional table

Record/Tuple: A row in a two-dimensional table

Super key: The set of attributes that can uniquely identify a tuple in a relation is called the super key of the relational model.

Candidate key: A superkey that does not contain any extra attributes.

Primary key: A candidate key selected by the user as a tuple identifier

Foreign key: used to associate two tables

Paradigm: A set of relational patterns that conform to a certain level. The tables in the database must follow certain rules.

This is the end of this article about what MySQL database does. For more information about what MySQL database is, please search for previous articles on 123WORDPRESS.COM or continue to browse the following related articles. I hope you will support 123WORDPRESS.COM in the future!