blocks|key|5346420|text|如何使用(您的视图称为viewname)|type|unstyled|depth|inlineStyleRanges|entityRanges|data|5346421|5346422|SHOW+CREATE+VIEW+viewname获取视图的SQL原样为|ordered-list-item|offset|length|style|CODE|5346423|DROP+VIEW+viewname删除视图|5346424|修改第一步中的SQL将新列添加到该SQL+|5346425|运行modified+SQL+|5346426|5346427|这将创建包含附加列的视图|5346428|http://dev.mysql.com/doc/refman/5.0/en/show-create-view.html|5346429|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|0|P|0|0|I|0|0|0|0|0|0|1O|0|0^^$0|@$1|2|3|4|5|6|7|11|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|12|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|13|8|@$F|14|G|15|H|I]]|9|@]|A|$]]|$1|J|3|K|5|E|7|16|8|@$F|17|G|18|H|I]]|9|@]|A|$]]|$1|L|3|M|5|E|7|19|8|@]|9|@]|A|$]]|$1|N|3|O|5|E|7|1A|8|@]|9|@]|A|$]]|$1|P|3|-4|5|6|7|1B|8|@]|9|@]|A|$]]|$1|Q|3|R|5|6|7|1C|8|@]|9|@]|A|$]]|$1|S|3|T|5|6|7|1D|8|@]|9|@$F|1E|G|1F|1|1G]]|A|$]]|$1|U|3|-4|5|6|7|1H|8|@]|9|@]|A|$]]]|V|$W|$5|X|Y|Z|A|$10|T]]]]

How about using (Your view is called viewname)

<ol>
<li><code>SHOW CREATE VIEW viewname</code> to get the SQL for the view as it is </li>
<li><code>DROP VIEW viewname</code> to remove the view</li>
<li>Modify the SQL from the first step to add the new column to that SQL </li>
<li>Run the modified SQL </li>
</ol>

That would create the view with the additional column(s)

<a href="http://dev.mysql.com/doc/refman/5.0/en/show-create-view.html" rel="noreferrer">http://dev.mysql.com/doc/refman/5.0/en/show-create-view.html</a>

blocks|key|5346625|text|为了获取视图进行编辑/更新，我们使用了两种方法：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|5346626|Step+1:+

select+your+view+in+phpmyadmin+and+click+Export(make+sure+click+check+box+of+Structure&+Add+DROP+VIEW)+&+GO.you'll+see+a+CREATE+VIEW++query+like+as:CREATE+ALGORITHM=UNDEFINED+DEFINER=`dbname`@`localhost`+SQL+SECURITY+DEFINER+VIEW+`vw_name`+AS+select+..etc..And+then+remove+'ALGORITHM.....to...DEFINER'+part+from+this+query+and+update/added+required+field/make+changes+to+the+query.and+then+execute+modified+view.`


step+2:

++++Run+the+query:+SHOW+CREATE+VIEW+`vw_name`
++++Expand+the+result+and+choose+Full+Texts.++++++++
++++Copy+entire+contents+of+the+Create+View+column.
++++Make+changes+to+the+query.
++++Run+the+query+directly+(with+out+the+CREATE+VIEW...+syntax)+to+make+sure+it+runs+as+you+expect+it+to.|code-block|syntax|javascript|5346627|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

To take the view for edit/update,we have used two way:

<pre><code>Step 1: 

select your view in phpmyadmin and click Export(make sure click check box of Structure&amp; Add DROP VIEW) &amp; GO.you'll see a CREATE VIEW query like as:CREATE ALGORITHM=UNDEFINED DEFINER=`dbname`@`localhost` SQL SECURITY DEFINER VIEW `vw_name` AS select ..etc..And then remove 'ALGORITHM.....to...DEFINER' part from this query and update/added required field/make changes to the query.and then execute modified view.`


step 2:

 Run the query: SHOW CREATE VIEW `vw_name`
 Expand the result and choose Full Texts. 
 Copy entire contents of the Create View column.
 Make changes to the query.
 Run the query directly (with out the CREATE VIEW... syntax) to make sure it runs as you expect it to.
</code></pre>

blocks|key|5828754|text|您还可以使用CREATE+OR+REPLACE+VIEW，以避免删除视图的步骤：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|5828755|5828756|show+create+view+viewname.Find+definition+in+'Create+View‘column|unordered-list-item|5828757|使用以下命令添加新列：CREATE+OR+REPLACE+VIEW|5828758|5828759|entityMap^0|6|M|0|0|0|P|0|B|M|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@$9|P|A|Q|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|R|8|@]|D|@]|E|$]]|$1|G|3|H|5|I|7|S|8|@$9|T|A|U|B|C]]|D|@]|E|$]]|$1|J|3|K|5|I|7|V|8|@$9|W|A|X|B|C]]|D|@]|E|$]]|$1|L|3|-4|5|6|7|Y|8|@]|D|@]|E|$]]|$1|M|3|-4|5|6|7|Z|8|@]|D|@]|E|$]]]|N|$]]

You can also use <code>CREATE OR REPLACE VIEW</code>, to avoid the step of dropping the view:

<ul>
<li><code>show create view viewname</code>. Find definition in 'Create View' column</li>
<li>use below command to add new columns: <code>CREATE OR REPLACE VIEW</code></li>
</ul>

blocks|key|759740|text|：更简单的方法|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|759741|大多数时候，无法编辑视图等是由于定义者被设置为root@localhost，如果您来自web主机控制面板，则该用户不是您。|759742|759743|单击主页(房屋图标)左上角，将您的用户名复制到右侧。|ordered-list-item|759744|在左侧单击您的视图>结构>编辑视图和编辑。|759745|将您的用户名粘贴到'root@localhost‘的位置，然后单击Go。|759746|759747|这已经在PHPMyAdmin+4.9.0.1上测试过了，它也可能在更早和更高的版本上工作。PHPMyAdmin似乎会在接下来的会话中记住您的用户名，以便您可以自由编辑。|759748|entityMap^0|0|5|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@$9|V|A|W|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|X|8|@]|D|@]|E|$]]|$1|H|3|-4|5|6|7|Y|8|@]|D|@]|E|$]]|$1|I|3|J|5|K|7|Z|8|@]|D|@]|E|$]]|$1|L|3|M|5|K|7|10|8|@]|D|@]|E|$]]|$1|N|3|O|5|K|7|11|8|@]|D|@]|E|$]]|$1|P|3|-4|5|6|7|12|8|@]|D|@]|E|$]]|$1|Q|3|R|5|6|7|13|8|@]|D|@]|E|$]]|$1|S|3|-4|5|6|7|14|8|@]|D|@]|E|$]]]|T|$]]

A Simpler Way

Most of the time, not being able to edit views etc. is due to the DEFINER being set to root@localhost, and if you're coming from a web host control panel, that user is not you.

<ol>
<li>Click Home (house icon) top left, copy your username to the right.</li>
<li>Click your view on the left > Structure > Edit View and edit.</li>
<li>Paste your username in place of 'root@localhost' and click Go.</li>
</ol>

This has been tested on PHPMyAdmin 4.9.0.1, it may also work on earlier and later versions. PHPMyAdmin seems to remember your username for the rest of the session, so that you can edit freely.

blocks|key|759644|text|在phpMyADmin上，转到导出->+(选择)‘快速-仅显示最小选项’->+GO。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|759645|这将为您提供您在文本文件中所做的create语句，查看或保存该文本文件，您应该有所有的信息。|759646|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

On phpMyADmin Go to Export -> (select) 'Quick - display only the minimal options' -> GO.

That will give you the create statements that you made in a text file, view or save that text file and you should have all the info there.

How can I update (or edit) a View in MySQL database using phpMyAdmin.

I got a view that's made of columns from two tables - I added a new column to one of these, but the view doesn't have it. I can't find the MySQL query I used to get this view (it's quite obscure one) - so how can I edit the MySQL query that created this view to add a new column into it?

How to update a view in phpMyAdmin?

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

聚焦“写作效率、视觉美观与运行性能”三方面进行全面升级，为您提供更高效、稳定的创作环境

社区富文本&Markdown编辑器全新改版上线，欢迎大家体验!

诚挚邀请您参与本次调研，分享您的真实使用感受与建议。您的反馈至关重要，感谢您的支持与参与！

社区新版编辑器体验调研

如何使用phpMyAdmin更新(或编辑) MySQL数据库中的视图。我得到了一个由两个表中的列组成的视图-我在其中一个表中添加了一个新列，但视图中没有它。我找不到用于获取该视图的MySQL查询(它相当模糊)-那么如何编辑创建该视图的MySQL查询以向其中添加新列呢？

问如何在phpMyAdmin中更新视图？
EN

回答 5

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在phpMyAdmin中更新视图？EN

回答 5

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在phpMyAdmin中更新视图？
EN