Shulou(Shulou.com)06/01 Report--

How do I modify the mysql view? This problem may be often seen in our daily study or work. I hope you can gain a lot from this question. The following is the reference content that the editor brings to you, let's take a look at it!

Mysql modify the view method: 1, if the view exists, then overwrite, if not, then create, the code is [create or replace view statement]; 2, through the alter statement to modify, the code is [alter view student_view (id,name....].

How mysql modifies the view:

1. Overwrite the view if it exists, and create it if it does not exist.

Create or replace view statement. Create or replace view algorith=temptable view student_view (nid,id,name) as select id,pid,title from student

2. Modify it through alter statement.

Alter view student_view (id,name,title) as select id,name,sex from student; Thank you for your reading! After reading the above, do you have a general idea of how to modify the mysql view? I hope the content of the article will be helpful to all of you. If you want to know more about the relevant articles, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.