视图(view)基本操作
创建视图
视图的本质是SQL指令(select语句)
基本语法:create view 视图名字 as select 指令;
备注:select语句可以是单表数据,也可以是连接查询、联合查询或者子查询
as除了给表取别名外(可忽略),此处意思为和...一样。
mysql> select * from teacher;
+------+------+
| name | age |
+------+------+
| 小明 | 26 |
| 小可 | 28 |
| 小云 | 22 |
+------+------+
3 rows in set (0.16 sec)
mysql> select * from student;
+----+------+
| id | name |
+----+------+
| 3 | 小艾 |
| 4 | 小新 |
| 6 | 小可 |
+----+------+
3 rows in set (0.00 sec)
-- 视图字段不允许重复!!!所以name只能出现一个
mysql> select s.*,age from student as s left join teacher t on s.name=t.name;
+----+------+------+
| id | name | age |
+----+------+------+
| 3 | 小艾 | NULL |
| 4 | 小新 | NULL |
| 6 | 小可 | 28 |
+----+------+------+
3 rows in se