一、MySql创建视图
CREATE VIEW 视图名 AS SELECT 查询语句;
注:将 SELECT 查询语句 替换成所写的sql语句
eg:
CREATE VIEW v_article AS SELECT A.title, A.content, A.author, C.name AS categoryName FROM article AS A JOIN articleCategory AS C ON A.articleCategoryId=C.articleCategoryId;
二、MySql视图修改
ALTER VIEW 视图名 AS SELECT 查询语句;
注:同上
三、MySql视图删除
DROP VIEW 视图名;
eg:
DROP VIEW v_article;
注:https://itbilu.com/database/mysql/E1q5C22_.html