显示所有视图:SELECT * from information_schema.VIEWS
创建视图:
CREATE [OR REPLACE] [ALGORITHM = {UNDEFINED | MERGE | TEMPTABLE}]VIEW view_name [(column_list)]
AS select_statement
[WITH [CASCADED | LOCAL] CHECK OPTION]
mysql> create view v_emp as select empno,ename,job from emp;
Query OK, 0 rows affected (0.00 sec)
Drop view view_name;