Open the navicat for mysql software and open the corresponding database. Then click View.
Click to create a new view. Here you can create it through sql statement.
Related recommendations: "Navicat for mysql usage graphic tutorial"
Of course You can choose navicat for mysql view creation tool to create it. As shown in the picture, move the tables one by one. If the primary and foreign key relationships of your table design are OK, they will automatically be connected online.
Then check the content you want to display as shown in the picture, and click Save. (Note that the selection must be made, it cannot be empty)
After using the tool to create the view, you can click Define to view the corresponding SQL statement of the view just now. This is navicat for Mysql generates it for you.
Then click on the view under the database, and you can view the effect of the view you just created. You can see that the view is essentially a composite table.
The above is the detailed content of How to create a view in navicat. For more information, please follow other related articles on the PHP Chinese website!