视图
1、创建视图
语法:create view 视图名 as SQL语句 例:create view view_name as select user_id,username,email from user;
2 、删除视图
语法:drop view 视图名称 例:drop view vuser
3、更改视图
update view_name set sal = 3333 where job = 'analyst';
视图
1、创建视图
语法:create view 视图名 as SQL语句 例:create view view_name as select user_id,username,email from user;
2 、删除视图
语法:drop view 视图名称 例:drop view vuser
3、更改视图
update view_name set sal = 3333 where job = 'analyst';