In mysql, a view is a virtual table, and the actual data comes from the basic table. Therefore, updating the data information in the view through insert, modify, and delete operations is essentially updating the basic table referenced by the view. Data information; syntax format "ALTER VIEW
AS
语句>
##(Recommended tutorial:
mysql video tutorial)
Modify view content
The view is a virtual table, and the actual data comes from the basic table, so updating the data in the view through insert, modify, and delete operations is essentially Updates the data in the base table referenced by the view.
Note: Modification of the view is a modification of the basic table, so when modifying, the data definition of the basic table must be met.
Basic syntax
You can use the ALTER VIEW statement to modify an existing view.
The syntax format is as follows:
ALTER VIEW <视图名> AS
Copy after login
The syntax description is as follows:
-
: Specify the name of the view. The name must be unique in the database and cannot have the same name as another table or view.
-