CREATE VIEW
CREATE VIEWA view is a virtual table that takes out a part of a table or joins necessary itemsfrom multiple tables to make it look like a single table.There are three advantages to using views:①Improve usability You pick out only the columns you need from the table, and you read the data easier. In addition, you can join multiple tables to create a single view and so it is possible to reduce the number of times to refer the data.②Improve security You can limit the range of data usage by giving permission to access the view. For example, you can disable data updates from the view, or if you don't want to expose all the data in the table, you can expose only the information except the s
0