How to create a view in navicat

Navicat for mysql is a view management tool for the mysql database. It allows us not to face the small screen like dos. The following is a graphic record of how I learned to use navicat for mysql to create views. Interested friends can take a look.

Recommended tutorial: MySQL introductory video

The official start is now

1. Open the navicat for mysql software and then open the corresponding database. Then click View.

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

3. Of course, you can also choose 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 automatically be connected online.

#4. Then tick the content you want to display as shown in the picture, and click Save. (Note that the selection must be made and cannot be empty)

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

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

Extension information

View refers to A view in a computer database 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, views do not exist as stored sets of data values ​​in the database. Row and column data come from the table referenced by the query that defines the view, and are generated dynamically when the view is referenced.

From a user's perspective, a view is a view of the data in the database from a specific perspective. From the inside of the database system, a view is a virtual table defined by a query consisting of SELECT statements. From the inside of the database system, a view is composed of data in one or more tables. From the outside of the database system, a view is just 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 act like filters. The filters that define a view can come from one or more tables in the current or other databases, or from other views. Distributed queries can also be used to define views that use data from multiple heterogeneous sources.

The view is the SQL statement of the query stored in the database. It is mainly used for two reasons: security reasons. The view can hide some data, such as the social security fund table. You can use the view to only display the name and address. , instead of displaying social security numbers and salary numbers, etc. Another reason is to make complex queries easier to understand and use.

　View: The way to view graphics or documents.

Once a view is defined, it is stored in the database. The corresponding data is not stored in the database again like a table. The data seen through the view is only stored in the basic table. data. The operations on views are the same as those on tables. They can be queried, modified (with certain restrictions), and deleted.

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

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