How to use mysql View

This article mainly explains "how to use mysql View". Interested friends may wish to have a look at it. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn how to use mysql view.

We will generally use the view for the query function, some functions can not be used, novice partners are very easy to step on the mine, let's take a look at the specific use of Mysql view.

1. The view is equivalent to a virtual table and can be used directly as a table.

Query view chart data

Select* from `0817-user`

2. Views are generally used for queries, not for update or delete operations. Because updating and deleting the view will have the same effect on the original table.

Therefore, in some cases, the view cannot be updated:

Including group by, distinct, having,union,join, etc.

Constant view

Otherwise, the following error will be reported:

At this point, I believe you have a deeper understanding of "the use of mysql view". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!