How to create a view on multiple tables in MySQL

In MySQL, create a view on two or more base tables

Create the stu_class view on the student table and stu_info table to query the s_id number, name, and class

First, create the stu_info table and insert data into it

View the data in the table

Create the stu_class view

View View

It can be seen that the created view contains id, name and class fields

Among them, the id field corresponds to the s_id field in the student table, the name field corresponds to the name field in the student table, and the class field corresponds to the class field in the stu_info table.