MySQL 视图
- 发布
- 分类
- MySQL
- 篇幅
- 2 字 / 1 分钟
- 阅读
- 346
视图
-- 创建
CREATE VIEW view_name AS
SELECT column1, column2
FROM table
WHERE condition
-- 修改
ALTER VIEW view_name AS
SELECT column1, column2
FROM table
WHERE condition
-- 删除
DROP VIEW view_name
-- 创建
CREATE VIEW view_name AS
SELECT column1, column2
FROM table
WHERE condition
-- 修改
ALTER VIEW view_name AS
SELECT column1, column2
FROM table
WHERE condition
-- 删除
DROP VIEW view_name