Shulou(Shulou.com)06/01 Report--

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

On the student table and the stu_ info table, create a stu_class view to query the sid number, name, and class

First, create the stu_info table and insert data into the table

View the data in the table

Create a stu_class view

View view

As you can see, the view created contains the id, name, and class fields

Where 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_ information table

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.