mysql中的视图

#视图创建：

create view view_name as select ......

#删除视图:
drop view view_name;

mysql> create view user as select user,password from mysql.user;
Query OK, 0 rows affected (0.03 sec)

mysql> select * from user;
+------+-------------------------------------------+
| user | password                                  |
+------+-------------------------------------------+
| root | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B |
| root | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B |
| root | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B |
+------+-------------------------------------------+
3 rows in set (0.00 sec)

mysql>