基础（四）：视图操作

「 MYSQL 」 August 19, 2018

基础（四）：视图操作

Words count 342 Reading time 1 mins. Read count 0

创建视图

CREATE  VIEW  VIEW_DEPT_DNO AS SELECT DEPTNO AOC_ID,
DNAME AOC_NAME,LOC AOC_LOC FROM DEPT WHERE LOC ="本部";

删除视图

DROP VIEW VIEW_DEPT_DNO;

shirukai

Alway believe that something wonderful is about to happen
0%