创建视图:create view view_t as select quantity,price,quantity*price from t;
create view stu_clas(id,name,class) as select student.d_id,student.name,sut_info.glass from student,sut_info where student.d_id = sut_info.s_id;
查看视图:
desc view_t
show table status like ‘view_t’\G
show create view view_t\G
use information_schema
select * from VIEWS\G
修改视图:
create or replace view view_t as select * from t;
create or replace view view_t as select quantity from t;
alter view view_t as select price from t;
update view_t set price = 5;
update t set price = 11;
insert (不能插入视图)
delete from view_t2 where price = 5;
删除视图:
drop view if exists view_t;
drop view view_t2;