MySQL database from delete library to running MySQL: view, trigger, transaction, stored procedure, function

A view

A view is a virtual table (not a real one), which is essentially "getting a dynamic dataset from an SQL statement and naming it", which you can use as a table by simply using "name" to get a result set.

Using views we can take out the temporary table in the query process, and use the view to implement, so that later on to manipulate the temporary table data without rewriting the complex SQL, directly to the view to find, but the view has obvious efficiency problems, and the view is stored in the database, If the SQL used in our program relies too much on the view in the database, which is strongly coupled, it means that it is very inconvenient to extend SQL, so it is not recommended to use

MySQL database from delete library to running MySQL: view, trigger, transaction, stored procedure, function