Mysql technology insider (version 4) Reading Notes (I), mysql insider

Mysql technology insider (version 4) Reading Notes (I), mysql insider

Question: I have been writing code for two years. I have learned a lot, but I don't have a good habit of recording, sharing, and forgetting many knowledge points, so from today on, I learned to record the details of my project like Daniel. First, I will read Mysql technology insider and write a complete reading note; let's go! Haha...

As a programmer, he must deal with databases, whether relational (SQL Server, MySql, Oracle, etc.) or non-relational (MongoDB, etc ); I think that as long as you have used or understood SQL, you have more or less mastered the terms and basic concepts of SQL, such as: Database (DB), Management System (MS), relationship (R ), I will not describe the concepts of these terms. You can search for them by yourself! In fact, I am not used to these conceptual things! For this reason, I use the following definitions to simplify the process:

Database Management System (RDBMS) = database (DB) + Management System (MS) + relationship (R)

To interact with Mysql, you must use SQL, a standardized database language, similar to the following:

Create table student (student_id int, student_name char (20), student_age int );

Mysql architecture: client/server architecture;
Let's write it here today. Let's take a look at Mysql and summarize the SQL statements in the next section! To be continued ...........