Question

SQL数据库 如何把表转换为视图

SQL数据库 如何把表转换为视图

Answer 1

create view 视图名称 as
selece 列1，列2，...... from 表名称

Answer 2

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