Mysql中关于视图操作的详解

create view view_name as 查询语句;

show tables;// 显示所有的表和视图

show create view view_name;

desc view_name;

show table status from table_name like 'view_name';

select * from view_name (where 条件);

alter view view_name as 查询语句;

create or replace view view_name as 查询语句;

drop view view_name;

create view view_name as select 常量;

create view view_test1 as select 3.1415926;

select * from view_test1;

create view view_name as select 函数(属性名) from table_name;

create view view test2 as select count(name) from t_student;

create view view_testt4 as select s.name from t_student as s,t_group as g where s.group_id = g.id and g.id = 2;

create view view_test5 as select s.name from t_student as s LEFT JOIN t_group as g on s.group_id = g.id where g.id = 2;

create vieww view_test6 as select s.name from t_student as s where s.group_id in (select id from t_group);

create view view_name as 查询语句1 UNION ALL 查询语句2;