mysql> select * from view12345; +----+--------+-------------+------+ | id | name | passwd | info | +----+--------+-------------+------+ | 4 | 喬雅 | as you wish | 23 |

根據(jù)視圖定義看到?視圖定義的時(shí)候是id < 5的。

mysql> show create view view12345; +-----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+ | View | Create View | character_set_client | collation_connection | +-----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+ | view12345 | CREATE ALGORITHM=UNDEFINED DEFINER=`skip-grants user`@`skip-grants host` SQL SECURITY DEFINER VIEW `view12345` AS select `view_11_2`.`id` AS `id`,`view_11_2`.`name` AS `name`,`view_11_2`.`passwd` AS `passwd`,`view_11_2`.`info` AS `info` from `view_11_2` where (`view_11_2`.`id` < 5) | utf8mb4 | utf8mb4_0900_ai_ci | +-----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+ 1 row in set (0.00 sec)

接下來(lái)，給id 更新，賦給id大于5的值也能夠成功，如下：

mysql> update view12345 set id = 122,name = '123',passwd = '888888',info = '1211' where id = 4; mysql> select * from user; +--------+----------+--------+-----------------+------------+ | userid | username | age | passwd | info | +--------+----------+--------+-----------------+------------+ | 6 | robert2 | 35 | change | change ok | | 8 | robert | 35 | 888888 | update | | 9 | robert | 35 | 123456 | update | | 122 | 123 | 123455 | 654321 | 1211 | | 5 | 喬木 | 121111 | you are so good | 13 | +--------+----------+--------+-----------------+------------+ 5 rows in set (0.00 sec)

總結(jié)：

視圖定義的時(shí)候如果不加上 with cascaded|local check option，那么視圖更新的時(shí)候就不用受約束。結(jié)果導(dǎo)致視圖中原有數(shù)據(jù)被破壞，這是一個(gè)非常令人惱怒的結(jié)果，所以定義視圖的時(shí)候，最好加上with check option

總結(jié)

以上是生活随笔為你收集整理的mysql更新视图的时候有时候可以不满足视图条件的值也能更新成功的全部?jī)?nèi)容，希望文章能夠幫你解決所遇到的問(wèn)題。

如果覺(jué)得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。