SQL view-CodePudding

After why SQL update the view to exit back to every time to see the update click refresh or can't see the update

CodePudding user response:

Can't see the update? What do you mean? Cut a picture

CodePudding user response:

reference 1/f, gypsy song response:

can't see the update? What do you mean? Cut a picture

is such as update the view1 set sname='15' where sno='0001' then click update to update can only have to open the database

CodePudding user response:

refer to the second floor weixin_46945613 response:

Quote: refer to 1st floor gypsy song response:
can't see the update? What do you mean? Cut a picture

is such as update the view1 set sname='15' where sno='0001' come then click update to update can only have to open the database

Update is complete, query language sentence have any change?

 select * from the view1 where sname='15'

CodePudding user response:

reference gypsy song reply: 3/f

Quote: refer to the second floor weixin_46945613 response:

Quote: refer to 1st floor gypsy song response:
can't see the update? What do you mean? Cut a picture

is such as update the view1 set sname='15' where sno='0001' come then click update to update can only have to open the database

Update is complete, query language sentence have any change?
select * from the view1 where sname='15'

change but only see a view point open view didn't change

CodePudding user response:

Weixin_46945613

reference 4 floor response:

Quote: refer to the third floor of gypsy song response:

Quote: refer to the second floor weixin_46945613 response:

Quote: refer to 1st floor gypsy song response:
can't see the update? What do you mean? Cut a picture

is such as update the view1 set sname='15' where sno='0001' come then click update to update can only have to open the database

Update is complete, query language sentence have any change?
select * from the view1 where sname='15'

change but it is not only some open view on view change

You did not send screenshots, don't quite understand what you said to see the view is what meaning,

However, what you say may be not update the data of the graphical interface,
Don't try so hard, the graphical interface used to have done well enough, if you learn oracle, mysql will find bad farther,
Update, maybe you experience a little, but the system pressure is likely to increase a lot, so less design,

Moreover, for a learning program, a graphical interface is in itself should not be so dependent on, everything is subject to a code
Write the code as much as possible,

CodePudding user response:

Read your messages, screenshots,
In fact, I understand that's right, in # 5 answer is just for you,

You press # 5 is ok, I don't expect updated in real time,
Even if one day you to write programs, updated in real time is a very not easy thing, updated regularly used up big, triggered update technology also has the certain difficulty,
In real-time update many things to consider, and for computer consumption is larger, there is no need to demanding SQL Serverr SSMS achieve this effect,