1.MYsql视图其实就是封装语句
2.创建视图:create view 视图名字 as 操作代码
create view view_product as select name from product;
3.修改视图:
(1):用alter语句修改:
alter view view_name as 查询语句:
例如:alter view view_product select id from product;
(2):利用create or replace 语句:
例如:create or replace view_product as select price from product;
4.通过视图查询数据:
(1):与通过表名查询完全一样:
select * from view_product ;
5:用视图添加数据:
(1);通过视图 : 添加数据各列的值分别为11,pear,123
若values后面的语句与各列值不一一对应:insert into view_product (id,name,price) values(11,pear,123);
若values后面的语句与各列值一一对应:insert into view_product values (11,pera,123);
(2):删除数据:
delect from view_product where name='pear';
(3):更新数据操作:
update view_product set price=3.5 where name='pear';