C.6 CREATE VIEW

CREATE VIEW用来创建一个或多个表上的新视图。详细内容请参阅第18课。

输入▼

CREATE VIEW viewname AS
SELECT columns, ...
FROM tables, ...
[WHERE ...]
[GROUP BY ...]
[HAVING ...];