Shulou(Shulou.com)06/01 Report--

This article mainly explains the MySql view trigger storage method, the content is clear, interested friends can learn, I believe it will be helpful after reading.

View:

When a temporary table is used repeatedly, give the temporary table an alias to facilitate later use, you can create a view, the alias is the name of the view. A view is just a virtual table in which the data is dynamically read from the physical table, so the physical table changes back to changing the view.

Create:

Create view v1 as SQL

For example: create view v1 as select * from student where sid

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.