创建视图sql
create view 视图名称 as 查询sql语句
create view test2 as select * from sc
test2 视图名称
select * from sc 查询语句

更多精彩
create view 视图名称 as 查询sql语句
create view test2 as select * from sc
test2 视图名称
select * from sc 查询语句