A brief discussion of MySQL drifting (1)
- 黄舟Original
- 2017-03-08 13:22:27912browse
Introduction:
MySQL is a relational database. It is a database based on the relational model. Various entities in the real world and various relationships between entities Relationships are represented by relational models.
The concept of relational model actually includes three layers: relational data structure, relational operation set and relational integrity constraints;
When it comes to relational types, there are naturally non-relational databases:
Degree Niang told us: Non-relational database products are functionally stripped versions of traditional relational databases. By reducing unused or rarely used functions, product performance can be greatly improved. To put it simply, it removes many unused ancillary functions. Personally, I think it can be understood as a "lite version"
Advantages of relational databases:
1. Complex queries can be easily executed using SQL statements. Do very complex data queries between one table and multiple tables.
2. Transaction support enables data access requirements with high security performance to be realized.
As for MySQL, the features are:
1) Fast running speed
2) Easy to use
3) Support query language
4) Multiple users can connect to the database at the same time, And it’s free and can run on various versions of UNIX and non-Unix systems;
It should be noted that MySQL is not case-sensitive on Windows, but table names are case-sensitive on Linux;
Introduction:
MySQL is a relational database, a database based on the relational model, various entities in the real world and various connections between entities All are represented by relational models.
The concept of relational model actually includes three layers: relational data structure, relational operation set and relational integrity constraints;
When it comes to relational types, there are naturally non-relational databases:
Degree Niang told us: Non-relational database products are functionally stripped versions of traditional relational databases. By reducing unused or rarely used functions, product performance can be greatly improved. To put it simply, it removes many unused ancillary functions. Personally, I think it can be understood as a "lite version"
Advantages of relational databases:
1. Complex queries can be easily executed using SQL statements. Do very complex data queries between one table and multiple tables.
2. Transaction support enables data access requirements with high security performance to be realized.
As for MySQL, the features are:
1) Fast running speed
2) Easy to use
3) Support query language
4) Multiple users can connect to the database at the same time, And it’s free and can run on various versions of UNIX and non-Unix systems;
It should be noted that MySQL is not case-sensitive on Windows, but table names are case-sensitive on Linux;
The above is the detailed content of A brief discussion of MySQL drifting (1). For more information, please follow other related articles on the PHP Chinese website!