视图
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';
MySQL基础
lhuan 2016-08-30 19:32 原文
视图
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';