Mysql-2-database base, mysql-2-Database

Mysql-2-database base, mysql-2-Database

(1) mysql is a small relational database management system.

(2) mysql is a fast, multithreading, multi-user, and robust SQL database server. Compared with other database management systems, mysql has the following advantages:

• Mysql is a relational database management system.
• Mysql is open-source.
• Mysql Server is a fast, reliable, and easy-to-use database server.
• The mysql server works on the client/server or embedded system.
• There are a large number of mysql software available.

(3) relational databases are relational databases based on relational models. They are databases that organize and access data based on the relationship between tables, tuples, and fields, it uses several tables to access data and links these tables.

(4) statements in the operating language of a relational database are classified into query statements and update statements.

(5) The core of the relational model principle is the standardization concept, which organizes the database into a process that minimizes the data structure while maintaining the integrity of the stored data. The standardized database must comply with the standardized rules of the relational model. Consistency can prevent inconsistent data and prevent data loss when using the database. Relational Model paradigms include the first paradigm, the second paradigm, the third paradigm, and BCNF paradigm. In these definitions, the advanced paradigm belongs to all geographic paradigms according to definitions. The relationship in the third paradigm belongs to the second paradigm, and the relationship in the second paradigm belongs to the first paradigm.