Query and delete mysql views

This tutorial describes how to query and delete the mysql view. You can use the show view name to query the view and delete the mysql view with the drop permission. However, you must have the drop permission to delete the view. Next let's take a look at the view.

This tutorial introducesMysql tutorial View queryAnd delete. Use the show view name to query the view,Delete mysql ViewIt is easy to use drop, but you must have the drop permission to delete a view. Next let's take a look at the view.

View the view Syntax "show tables;" or "show tables status". You can not only view the view name in the table, but also view other related information, such as an instance.

-> Show tables;

St

Stff

Staroo

26 row in set (0.00 sec );

-> Show tables status like 'st' G

Name: st

Engine: NULL

Version: NUll

.....

.

To queryViewCan be viewed using the show create view command.

-> Show create view st list G

View: st

Create View: create algorithm = udefined definer = 'root @ localhost' SQL ....

And so on. If you do not write anything else, you can test it in mysql.

Now let's take a look.Mysql Delete ViewInstance

Syntax:

Drop view [if exists] view_name [, viewname]... [restrict | casede]

For example, to delete the st View

-> Drop view st;

Query OK, 0 rows affected (0.00 sec );

This site Original article reprinted Indicate source http://www.bKjia. c0m/database/database.html