SQLite 视图

视图是保存的查询：CREATE VIEW / DROP VIEW；只读，除非用 INSTEAD OF 触发器。

Intermediate

Key PointsSQLite,VIEW,视图

讲解

视图是保存的查询：CREATE VIEW / DROP VIEW；只读，除非用 INSTEAD OF 触发器。

SQL

CREATE VIEW us_sites AS
SELECT name FROM company WHERE country = 'US';

SELECT * FROM us_sites;
DROP VIEW us_sites;

视图是保存的查询：CREATE VIEW / DROP VIEW；只读，除非用 INSTEAD OF 触发器。

SQL

CREATE VIEW us_sites AS
SELECT name FROM company WHERE country = 'US';

SELECT * FROM us_sites;
DROP VIEW us_sites;