Home>Article>Database> How navicat creates views

How navicat creates views

爱喝马黛茶的安东尼
爱喝马黛茶的安东尼 Original
2019-08-07 11:48:33 5652browse

How navicat creates views

After opening the navicat for mysql software, open the corresponding database, and then click View.

How navicat creates views

Click to create a new view. Here you can create it through sql statement.

How navicat creates views

How navicat creates views

Related recommendations: "Navicat for mysql usage graphic tutorial"

Of course You can choose 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.

How navicat creates views

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

How navicat creates views

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.

How navicat creates views

Then click on 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.

How navicat creates views

The above is the detailed content of How navicat creates views. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article:Navicat reports 2013 error Next article:Navicat reports 2013 error