How to use navicat view

Navicat for mysql is a view management tool for the mysql database. It allows us not to face the small screen like dos.

Open the navicat for mysql software and open the corresponding database. Then click [View]. (Recommended tutorial: navicat tutorial)

Click [New View]. Here you can create it through sql statement.

Of course, you can also select the 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 be automatically 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 view is essentially a composite table.

#When creating a view, make sure that the relationships between the tables are correct.

The above is the detailed content of How to use navicat view. For more information, please follow other related articles on the PHP Chinese website!