MySQL----view

View: is a virtual table, which is the essence of your own definition of a query SQL statement, through this view (statement), you each time to get the view data is equivalent to using a SQL statement even query, generate dynamic datasets (data do not need you to add, when you go to get data is, The view is automatically queried according to its own SQK statement)

Create a View

Create VIEW v1 AS

Select name, age from info where age>10

You can also modify a view to delete an operation

Delete using Drop View V1

The beginning of the modification is to reset the query statement, equivalent to delete the original, and then regenerate a view with the same name

Alter VIEW v1 AS

SELECT * FROM Info

For the view we can only query it, can not be modified or deleted (unable to manipulate the real data)

MySQL----view