Home | 简体中文 | 繁体中文 | 杂文 | Search | ITEYE 博客 | OSChina 博客 | Facebook | Linkedin | 作品与服务 | Email

40.6. 视图(View)

CREATE VIEW view_name AS
SELECT column_name(s)
FROM table_name
WHERE condition
		

update view

SQL CREATE OR REPLACE VIEW Syntax
CREATE OR REPLACE VIEW view_name AS
SELECT column_name(s)
FROM table_name
WHERE condition
		
comments powered by Disqus