SQL学习记事本。
use db
创建视图
create view v_db as
select name,sex,age
from user
where age > 20
查询
select * from v_db
修改视图(更新)
alter view v_db as
select name,sex,age
from user
where age > 30
删除视图
drop view v_db
SQL学习记事本。
use db
创建视图
create view v_db as
select name,sex,age
from user
where age > 20
查询
select * from v_db
修改视图(更新)
alter view v_db as
select name,sex,age
from user
where age > 30
删除视图
drop view v_db