How to delete views in mysql data table

This article mainly introduces to you how to delete the view in the mysql data table.

In the previous article, we have introduced you to the relevant knowledge of views. I believe you already have a certain understanding of mysql views.

The view is the SQL statement of the query stored in the database. We have also mentioned before that the view is like the basic table of mysql. What operations can be performed on the table are basically the same as for the view. Can. Such as view creation, query, modification, deletion, addition and other operations.

So for an introduction to the create, query and modify operations of views, friends who need to know more can refer to these articles.

[How to create a view in mysql? 】

【How to query the view in the mysql data table】

【How to modify the view in the Mysql data table】

Let’s continue to introduce the method of deleting views with simple examples.

We can delete the view only when it is determined that it is no longer needed.

Delete view syntax:

Drop view + 视图名 ;

Delete view syntax example:

Drop view + my_v1 ;

Here we delete the view my_v1.

In addition to directly using the command line tool to delete, you can also directly delete it through the Navicat data management tool

As shown in the view module, click Just delete the column of the view.

Note:

When deleting a view, only the definition of the view can be deleted, and the data in the actual mysql data table will not be deleted. Delete one or Multiple views use the DROP VIEW statement!

This article is about how to delete the MySQL data table. It is also very simple. I hope it will be helpful to friends in need!

If you want to know moremysql knowledge, you can follow the mysql video tutorial on the PHP Chinese website. Everyone is welcome to refer to and learn!

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