可以将某个22元的商品价格改为18元的视图是? create view v1 as select * from goods where price>20 create view v2 as select * from goods where price<20 create view v3 as select * from goods where price>20 with check option create view v4 as select * from goods where price<20 with check option

可以将某个22元的商品价格改为18元的视图是?

create view v1 as select * from goods where price>20

create view v2 as select * from goods where price<20

create view v3 as select * from goods where price>20 with check option

create view v4 as select * from goods where price<20 with check option

举报纠错

切换

1 个答案

转载: 强制视图上执行的所有数据修改语句都必须符合由 select_statement 设置的准则。通过视图修改行时，WITH CHECK OPTION 可确保提交修改后，仍可通过视图看到修改的数据

还没有评论

切换

撰写答案

扫描后移动端查看本题