create view 视图名称 as 查询sql语句create view test2 as select * from sctest2 视图名称select * from sc 查询语句
创建视图sql
原文：https://www.cnblogs.com/liyunchuan/p/10712300.html
