一、视图的创建
CREATE VIEW 视图名称 [(列名列表)] AS 查询语句;
eg:
CREATE
VIEW
city_country2 (city_id,city_name,cid,country_name)
AS
SELECT t1.*,t2.country_name FROM city t1,country t2 WHERE t1.cid=t2.id;
二、视图的修改
1、修改视图数据
UPDATE 视图名称 SET 列名=值 WHERE 条件;
eg:
UPDATE city_country SET city_name='北京市' WHERE city_name='北京';
注意:视图表数据修改,会自动修改源表中的数据
2、修改视图结构
ALTER VIEW 视图名称 [(列名列表)] AS 查询语句;
eg:
ALTER
VIEW
city_country2 (id,city_name,cid,country_name)
AS
SELECT t1.*,t2.country_name FROM city t1,country t2 WHERE t1.cid=t2.id;
三、删除视图
DROP VIEW [IF EXISTS] 视图名称;
eg:
DROP VIEW IF EXISTS city_country2;