mysql视图、存储过程、函数、索引全解析

创建视图：

-格式：CREATE VIEW 视图名称 AS  SQL语句

CREATE VIEW v1 AS

SELET nid,

    name

FROM

    A

WHERE

nid > 4

删除视图：

--格式：DROP VIEW 视图名称

DROP VIEW v1

修改视图：

- 格式：ALTER VIEW 视图名称 AS SQL语句

ALTER VIEW v1 AS

SELET A.nid,

    B. NAME

FROM

    A

LEFT JOIN B ON A.id = B.nid

LEFT JOIN C ON A.id = C.nid

WHERE

    A.id > 2

AND C.nid < 5