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

This article mainly introduces how to use navicat view, has a certain reference value, friends in need can refer to. I hope you will learn a lot after reading this article. Next, let the editor take you to learn about it.

Navicat for mysql is a view management tool for mysql database, which allows us to avoid having to face small pictures like dos.

Open the appropriate database after opening the navicat for mysql software. Then click [View].

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

Of course, you can also choose the navicat for mysql view creation tool to create. As shown in the figure, move the tables one by one, and if there is no problem with the relationship between the primary and foreign keys of your table design, they will be connected automatically.

Then tick the content you want to display as shown in the picture, and click Save. (be careful to choose, not all empty)

After you have created the view with the tool, you can click the definition to view the corresponding sql statement of the view just now, which is generated by navicat for mysql for you.

Then click on the bottom view of the database, and you can see the view you just created. You can see that the view is essentially a composite table.

Create a view to ensure that the association of the table is correct.

Thank you for reading this article carefully. I hope it will be helpful for everyone to share navicat views on how to use the content. At the same time, I also hope that you will support us, pay attention to the industry information channel, and find out if you encounter problems. Detailed solutions are waiting for you to learn!

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.