创建:
CREATE VIEW [view_name] AS
SELECT column_name(s)
FROM table_name
WHERE condition
查询:
SELECT * FROM [view_name]
删除视图:
DROP VIEW view_name
创建:
CREATE VIEW [view_name] AS
SELECT column_name(s)
FROM table_name
WHERE condition
查询:
SELECT * FROM [view_name]
删除视图:
DROP VIEW view_name