Mysql视图介绍

(3).修改视图

　　alter view [视图名] as [select语句];

mysql> alter view st as select * from user_tb where id=2;
Query OK, 0 rows affected (0.01 sec)

mysql> select name from st;
+------+
| name |
+------+
| lisi |
+------+
1 row in set (0.00 sec)

(4).删除视图

　　drop view [视图名];

mysql> drop view st;
Query OK, 0 rows affected (0.01 sec)

mysql> select * from st;
ERROR 1146 (42S02): Table ‘test_db.st‘ doesn‘t exist

Mysql视图介绍

标签：操作   通过   使用   ica   query   name   pre   drop   --