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

View

View is a virtual table (not real), its essence is [get dynamic data set according to SQL statement and name it], users only need to use [name] to get the result set, and can use it as a table.

Create a view:

Create view v1 asselect * from student where id > 100

In the future, you can directly pass:

Select * from v1; # directly access information with ID greater than 100

Delete the view:

Drop view v1

Modify the view:

Alter view v1 asselect id,name from student where id

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.