两种方法
1.直接点创建视图
定义里写入,可在SQL预览里查看
SELECT * FROM student where age<18
2.新建查询语句DQL
CREATE view student_age_little18 as
SELECT * FROM student where age<18;
定义里写入,可在SQL预览里查看
SELECT * FROM student where age<18
CREATE view student_age_little18 as
SELECT * FROM student where age<18;