Concept of MySQL database

Learn database knowledge, write a blog, and sort out and consolidate knowledge. Let's take an example of what a database is. It may not be accurate enough to understand the general meaning. To learn deeply, you should read a book.

Let's talk about examples of data in life: in a middle school, what are the basic information and records of students? The name, age, and hometown of the student are recorded. The traditional method is to draw a table on a piece of paper (see below) and then fill in the corresponding data. This table records the names, ages, and hometown of all students in a class. If there are 10 classes in the first grade, 8 classes in the second grade, and 15 classes in the third grade, there will be 10 such tables in the first grade, and 8 in the second grade, there will be 15 sheets in the third grade, and then they will be packed in a portfolio and handed over to Aunt Wang for management. Later, I want to query the information of a student. I just need to find Aunt Wang. Common databases include oracle, sqlser, mysql, and access. MySQL is a type of database management system. The following figure helps you understand the image.