MySQL基础

视图

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';