--视图学习
use sqltest
select * from saving
select * from stock
select * from out_stock
/*
*操作(增删改查)参考table的操作,基本相同
*/
--创建视图
create view view1(stock_id,stock_name,speci,warehouse)
as
select stock_id,stock_name,speci,warehouse from stock where warehouse='救灾1#'
with check option;
--查
select * from view1
--删除视图
drop view view1
--查入(有with check option不能插入)
insert into view1(stock_id,stock_name,speci) values(5,'方便面','n1')
视图学习
最新推荐文章于 2022-08-16 17:24:04 发布