Skip to content Skip to sidebar Skip to footer

1. 若视图是由两个以上基本表导出的,则此视图不允许更新。

2. 若视图的字段来自字段表达式或常数,则不允许对此视图执行INSERT和UPDATE操作,但允许执行DELETE操作。

3. 若视图的字段来自集函数,则此视图不允许更新。

4. 若视图定义中含有GROUP BY子句,则此视图不允许更新。

5. 若视图定义中含有DISTINCT短语,则此视图不允许更新。

6. 若视图定义中有嵌套查询,并且内层查询的FROM子句中涉及的表也是导出该视图的基本表,则此视图不允许更新。例如将成绩在平均成绩之上的元组定义成一个视图GOOD_SC: CREATE VIEW GOOD_SC AS SELECT Sno, Cno, Grade FROM SC WHERE Grade> (SELECT AVG(Grade) FROM SC);   导出视图GOOD_SC的基本表是SC,内层查询中涉及的表也是SC,所以视图GOOD_SC是不允许更新的。

7. 一个不允许更新的视图上定义的视图也不允许更新。

我自己用mysql测试过,条件一在一定情况下也可以更新,即是可能视图涉及多个表,也可以更新。

13 Comments

  • hdfilmcehennemi
    Posted 2022-12-08 22:15

    At this moment I am ready to do my breakfast, when having my breakfast coming again to read other news. Barrett Colden

  • sikis
    Posted 2022-08-20 15:02

    Hi, constantly i used to check webpage posts here in the early hours in the daylight, because i love to learn more and more. Enoch Beurskens

  • porno
    Posted 2022-08-20 14:00

    I like the helpful info you provide in your articles. I will bookmark your blog and check again here regularly. Horace Hammersmith

  • freespin
    Posted 2022-08-19 20:46

    Hello, for all time i used to check website posts here in the early hours in the dawn, because i love to gain knowledge of more and more. Roger Vergari

  • porno
    Posted 2022-08-16 12:33

    Thanks so much for the post. Really thank you! Much obliged. Luke Bashor

  • liseli
    Posted 2022-08-15 05:11

    Pretty nice post. I simply stumbled upon your blog and wanted to mention that I have really enjoyed surfing around your blog posts. Hugh Maio

  • bahis
    Posted 2022-08-15 04:47

    Thank you for your article. Really looking forward to read more. Great. Faustino Justo

  • buy viagra
    Posted 2022-08-09 18:21

    Looks like it has been a while since a post, but your since of sensuality is still great. Junior Vesely

  • bahis
    Posted 2022-08-09 17:39

    Appreciation to my father who shared with me concerning this webpage, this weblog is truly awesome. Horacio Besherse

  • casino
    Posted 2022-08-07 03:15

    There is obviously a bunch to realize about this. I assume you made various nice points in features also. Palmer Checketts

  • bahis
    Posted 2022-07-31 00:09

    These are genuinely enormous ideas in concerning blogging. Frank Sharley

  • viagra
    Posted 2022-07-29 18:38

    Really enjoyed this article. Really thank you! Fantastic. Marquis Spigner

  • eskort
    Posted 2022-07-20 17:22

    I absolutely love your blog.. Excellent colors & theme. Mohammad Guinle

Leave a comment