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 know it!

Let's officially begin.

1. Open the corresponding database after opening the navicat for mysql software. Then click View.

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

3. 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.

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

5. After creating 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.

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

Extended data

A view refers to a view in a computer database, which is a virtual table whose contents are defined by a query. Like a real table, a view contains a series of named columns and rows of data. However, the view does not exist in the database as a set of stored data values. Row and column data to freely define the table referenced by the view's query, and dynamically generated when the view is referenced.

From the user's point of view, a view looks at the data in the database from a specific perspective. From within the database system, a view is a virtual table defined by a query made up of SELECT statements. From the inside of the database system, the view is made up of data from one or more tables, and from the outside of the database system, the view is like a table. Views can be queried, but cannot be added, deleted, or modified.

A view is a virtual table whose contents are defined by a query. Like real tables, views function like filtering. Filters that define views can come from one or more tables in the current or other database, or from other views. Distributed queries can also be used to define views that use multiple heterogeneous source data.

View is stored in the database query SQL statement, it is mainly for two reasons: security reasons, the view can hide some data, such as: social insurance fund table, you can use the view to show only the name, address, but not the social security number and salary, etc., another reason is that it can make complex queries easy to understand and use.

View: how to view a drawing or document.

Once the view is defined, it is stored in the database, and the corresponding data is not stored in the database like the table. The data seen through the view is only the data stored in the basic table. The operation on the view is the same as on the table, which can be queried, modified (with certain restrictions), and deleted.

When the data seen through the view is modified, the data of the corresponding basic table will also change, and at the same time, if the data of the basic table changes, the change can be automatically reflected in the view.

These are all the contents of the 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.