1, there is A piece of A, the table, after the search results, created as A new form B (include query data), if change after the original data in A table, table B data will change excuse me?
2, if the query result created as a temporary table, the table data after the change, change data of temporary tables?

CodePudding user response:

The view will meet your requirements

CodePudding user response:

New watch the original table has no relationship with you, the original table change won't affect the new table

As the old gu said, can only use the view

CodePudding user response:

refer to the second floor of gypsy song response:

new watch the original table has no relationship with you, the original table change won't affect the new table

As the old gu said, can only use the view

Thank you all!

CodePudding user response:

Index view, this will cache the results view, and changes over the source table data (limit index view, of course, there are certain requirements, specific look at the information on the online help)