Features of the MYSQL View

The execution efficiency of a view is similar to that of a stored nickname. However, the execution efficiency of the simplest single SQL statement is higher. The reason is that the data in the view is not stored in the database as a dataset. Generally, a view does not have data. All its data must be dynamically generated when a view is referenced. Then you execute an SQL statement to query the view. At this time, the view must execute the SQL statement when creating the view to dynamically generate data, in this way, two SQL statements are executed, and only one single SQL statement is used. www.2cto.com is not suitable for the view with a slow view in any situation. Compared with the stored procedure, views are more inclined to protect data security. Set access restrictions to create a view: create view viewname as select statement Delete view: drop view viewname author justice85