##创建视图
CREATE VIEW v_student AS
SELECT studentNo, studentname, sex FROM student;
##删除视图
DROP VIEW v_student;
##查看视图
SELECT * FROM v_student;
##创建视图
CREATE VIEW v_student AS
SELECT studentNo, studentname, sex FROM student;
##删除视图
DROP VIEW v_student;
##查看视图
SELECT * FROM v_student;