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

Editor to share with you the operation of navicat to create a view, I hope you will learn a lot after reading this article, let's discuss it together!

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.

After reading this article, I believe you have a certain understanding of the operation of navicat to create views. You want to know more about it. Welcome to follow the industry information channel. Thank you for your reading!

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.