The view is to treat the result set as a table for query, so I just want to make it worse than the original table .. I think the only advantage is that the SQL statement seems to be a little shorter. Under what circumstances should I use the view? The view is to treat the result set as a table for query, so I just want to make it worse than the original table .. I think the only benefit is that SQL statements seem to be shorter ,,
Under what circumstances should a view be used?
Reply content:
The view is to treat the result set as a table for query, so I just want to make it worse than the original table .. I think the only benefit is that SQL statements seem to be shorter ,,
Under what circumstances should a view be used?
1. to simplify the operation, you can define a view for frequently used queries so that you do not have to specify conditions for the same query operation
2. Increase Data Security. Through the view, you can only query and modify specified data.
3. Improve the logical independence of the table, and the view can shield the impact of changes in the original table structure.
Http://www.jb51.net/article/36363.htm