How to delete a view in mysql?

In mysql, you can use the "DROP VIEW" statement to delete a view. The syntax format is "DROP VIEW [, ...]". The "DROP VIEW" statement can delete multiple views at one time, but you must have DROP permission on each view.

(Recommended tutorial: mysql video tutorial)

Deleting a view means deleting MySQL A view that already exists in the database. When you delete a view, only the definition of the view is deleted, but the data is not deleted.

Basic syntax

You can use the DROP VIEW statement to delete a view.

The syntax format is as follows:

DROP VIEW <视图名1> [ , <视图名2> …]

Among them: <View name>Specify the name of the view to be deleted. DROP VIEW statement can delete multiple views at one time, but you must have DROP permission on each view.

Delete view

[Example] Delete the v_students_info view. The input SQL statement and execution process are as follows.

mysql> DROP VIEW IF EXISTS v_students_info;
Query OK, 0 rows affected (0.00 sec)
mysql> SHOW CREATE VIEW v_students_info;
ERROR 1146 (42S02): Table 'test_db.v_students_info' doesn't exist

You can see that the v_students_info view no longer exists and it was successfully deleted.

The above is the detailed content of How to delete a view in mysql?. For more information, please follow other related articles on the PHP Chinese website!