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

Editor to share with you how to create a view of navicat, I believe that most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to understand it!

After opening the navicat for mysql software, open the appropriate database, and 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.

The above is all the content of this article "how to create views in navicat". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

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.