MySQL Tutorial Database

This article mainly introduces you to the basic knowledge of mysql database.

Recommended reference tutorial: "mysql tutorial"

Database

1, Definition

Database can be simply explained as: An efficient medium for storing and processing data (mainly divided into two types: disk and memory) .

2. Classification

According to different database storage media, it can be divided into two categories: relational database (SQL) and non-relational database (NoSQL, Not Only SQL) .

3. Example

Relational database:

• Large-scale: Oracle, DB2, etc.;

• Medium: SQL Server, MySQL, etc.;

• Small: Access, etc.

Non-relational databases:

• Memcached, MongoDB and Redis, etc.

4. Difference

Relational database:

• Safe, it saves data to disk and is basically unsafe Data loss may occur;

• is a waste of space because it stores data in the form of a two-dimensional table.

Non-relational database:

• The efficiency of storing data is relatively high;

• is not special Safe, sudden power outage can cause data loss.

Database

1. Definition

Database can be simply explained as: An efficient medium for storing and processing data (mainly divided into For disk and memory) .

2. Classification

According to different database storage media, it can be divided into two categories: relational database (SQL) and non-relational database (NoSQL, Not Only SQL) .

3. Example

Relational database:

• Large-scale: Oracle, DB2, etc.;

• Medium: SQL Server, MySQL, etc.;

• Small: Access, etc.

Non-relational databases:

• Memcached, MongoDB and Redis, etc.

4. Difference

Relational database:

• Safe, it saves data to disk and is basically unsafe Data loss may occur;

• is a waste of space because it stores data in the form of a two-dimensional table.

Non-relational database:

• The efficiency of storing data is relatively high;

• is not special Safe, sudden power outage can cause data loss.

The above is the detailed content of MySQL Tutorial Database. For more information, please follow other related articles on the PHP Chinese website!