Shulou(Shulou.com)06/01 Report--

The following mainly brings you the basic knowledge of MySQL database. I hope these contents can bring you practical use. This is also the main purpose of this article that I edit the basic knowledge of MySQL database. All right, don't talk too much nonsense, let's just read the following.

Database 1, definition

Database, can be simply interpreted as: efficient storage and processing of data media (mainly divided into disk and memory).

2. Classification

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

3. Give an example

Relational database:

Large: Oracle, DB2, etc.

Medium: SQL Server, MySQL, etc.

Small: Access and so on.

Non-relational databases:

Memcached, MongoDB and Redis, etc.

4. Difference

Relational database:

Security, which saves data to disk, and it is almost impossible to lose data

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

Non-relational databases:

The efficiency of storing data is high.

It is not particularly safe, and a sudden power outage can lead to data loss.

Database 1, definition

Database, can be simply interpreted as: efficient storage and processing of data media (mainly divided into disk and memory).

2. Classification

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

3. Give an example

Relational database:

Large: Oracle, DB2, etc.

Medium: SQL Server, MySQL, etc.

Small: Access and so on.

Non-relational databases:

Memcached, MongoDB and Redis, etc.

4. Difference

Relational database:

Security, which saves data to disk, and it is almost impossible to lose data

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

Non-relational databases:

The efficiency of storing data is high.

It is not particularly safe, and a sudden power outage can lead to data loss.

For the above basic knowledge of MySQL database, we do not think it is very helpful. If you need to know more, please continue to follow our industry information. I'm sure you'll like it.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.