Shulou(Shulou.com)05/31 Report--

This article focuses on "how to use mysql View". Interested friends may wish to take a look at it. The method introduced in this paper is simple, fast and practical. Let's let the editor show you how to use 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 "how to use the 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!

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.