优点:在总结中有写,安全、清晰 。
缺点:的话感觉就是如果需要额外的字段就需要更新视图吧...(感觉说的也不对
更新视图对基本表数据有影响。(比如update视图实际上就是对基本表的更新操作)
证明如下:
mysql> select * from team_score;
+---------+-----------+-----------+--------------+--------------+------------+
| game_id | h_team_id | v_team_id | h_team_score | v_team_score | game_date |
+---------+-----------+-----------+--------------+--------------+------------+
| 10001 | 1001 | 1002 | 102 | 111 | 2019-04-01 |
| 10002 | 1002 | 1003 | 135 | 134 | 2019-04-10 |
+---------+-----------+-----------+--------------+--------------+------------+
2 rows in set (0.00 sec)
mysql> create view h_team_score as select game_id, h_team_score from team_score;
Query OK, 0 rows affected (0.01 sec)
mysql> update h_team_score set h_team_score=103 where game_id=10001;
Query OK, 1 row affected (0.01 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> select * from team_score;
+---------+-----------+-----------+--------------+--------------+------------+
| game_id | h_team_id | v_team_id | h_team_score | v_team_score | game_date |
+---------+-----------+-----------+--------------+--------------+------------+
| 10001 | 1001 | 1002 | 103 | 111 | 2019-04-01 |
| 10002 | 1002 | 1003 | 135 | 134 | 2019-04-10 |
+---------+-----------+-----------+--------------+--------------+------------+
2 rows in set (0.00 sec)
展开