MySQL View modification and view Update syntax instance

We talked about the view created in the front, today this tutorial we will talk about the MySQL tutorial view changes and updates.

View Modifications .

Grammar:

Alter [Algorithm ={undefined |merge | temptable}] View view_name [(collist)] as SELECT [with [Case |local] Check option]

Let's start by creating a simple view

Create or Replace view 111cnNet as SELECT * from net111 where id=5;

Above is a query www.111cn.net table with a record with ID 5 in the View creation statement We are going to modify the MySQL view of the query id=6 or 7

Alter VIEW 111cnNet AS SELECT * from net111 where ID in (6,7) and url= ' http://www.111cn.net ';

So the view above is modified.

Original articles reproduced in this site annotated from http://www.111cn.net/database/database.html