这是视图内容:
SELECT *
FROM students
WHERE Sex = 'M';
修改视图
CREATE OR REPLACE VIEW studentBySexAndClass
AS
SELECT *
FROM students
WHERE Sex = 'M' and class='一年级';
这是视图内容:
SELECT *
FROM students
WHERE Sex = 'M';
修改视图
CREATE OR REPLACE VIEW studentBySexAndClass
AS
SELECT *
FROM students
WHERE Sex = 'M' and class='一年级';