Briefly introduce the basic knowledge of MySQL database
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.
