MySQL 如何基于另一个现有视图创建MySQL视图？

在MySQL中，我们可以创建一个基于另一个现有视图的视图。 为了让它理解，我们拥有以下数据的视图“Info”-

mysql> Create view info AS Select Id，Name，Subject FROM student_info;
Query OK，0 rows affected (0.11 sec)

mysql> Select * from Info;
+------+---------+------------+
| Id   | Name    | Subject    |
+------+---------+------------+
| 101  | YashPal | History    |
| 105  | Gaurav  | Literature |
| 125  | Raman   | Computers  |
| NULL | Ram     | Computers  |
+------+---------+------------+
4 rows in set (0.00 sec)

现在，我们使用以下查询的帮助创建另一个基于现有视图“info”的视图“info_less” –

mysql> Create view info_less AS Select Id, Name, Subject FROM info WHERE id >= 120;
Query OK，0 rows affected (0.25 sec)

mysql> Select * from info_less;
+------+-------+-----------+
| Id   | Name  | Subject   |
+------+-------+-----------+
| 125  | Raman | Computers |
+------+-------+-----------+
1 row in set (0.03 sec)

阅读更多：MySQL 教程