Skip to main content

View

建立View​

  • View是虛擬的表格
  • 使用SELECT語法來建立View
  • View永遠是最新內容
  • 每次User使用View資料庫系統都會按照SELECT重新建立一次View
################# 語法如下:
CREATE VIEW viewname AS
SELECT columnname 
FROM tablename
WHERE condition;

CREATE OR REPLACE VIEW viewname AS
SELECT columnname 
FROM tablename
WHERE condition;

################# 範例如下:
CREATE VIEW bookview AS
SELECT isbn, bookname, price FROM book WHERE price>1000;

查詢View​

SELECT * FROM bookview;

刪除View​

DROP VIEW bookview;