操作指令 | 代码 |
---|---|
创建视图 | CREATE VIEW 视图名(列1,列2...) AS SELECT (列1,列2...) FROM ...; |
使用视图 | 当成表使用 |
修改视图 | CREATE OR REPLACE VIEW 视图名 AS SELECT [...] FROM [...]; |
查看数据库已有视图 | >SHOW TABLES [like...];(可以使用模糊查找) |
查看视图详情 | DESC 视图名或者SHOW FIELDS FROM 视图名 |
视图条件限制 | [WITH CHECK OPTION] |
删除视图 | DROP VIEW 视图名 |
CREATE VIEW V_HelpPower AS
select t.JY_ID,c.BUILD_ID,d.DWID,t.JY_MC,t.JY_TYPE,a.DICT_DESC as 'JY_TYPE_NAME',t.JY_AREA ,b.DICT_DESC as 'JY_AREA_NAME',d.BUILD_NAME,t.XXDZ,t.LXR,t.LXFS
from (T_RMCF_SYS_SHJYLL t
INNER JOIN T_RMCF_SYS_DICT a
on t.JY_TYPE=a.DICT_NO and a.DICT_DMFLBM='JYLXDM'
INNER JOIN T_RMCF_SYS_DICT b
on t.JY_AREA=b.DICT_NO and b.DICT_DMFLBM='JYQYDM'
INNER JOIN T_RMCF_SYS_SHJYLL_BUILD c
on t.JY_ID=c.JY_ID
left outer JOIN T_RMCF_SYS_BUILD d
on c.BUILD_ID=d.BUILD_ID
);