如何使用phpMyAdmin 3.2.4编辑视图？ [英] How can I edit a view using phpMyAdmin 3.2.4?
本文介绍了如何使用phpMyAdmin 3.2.4编辑视图？的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
我需要在phpMyAdmin 3.2.4中简单地编辑一个非常复杂的视图，但我不知道如何做。有什么建议么？
谢谢！
I need to simply edit a very complicated view in phpMyAdmin 3.2.4 but I cannot figure how to do that. Any suggestions? Thanks!
推荐答案
要扩展一个CheeseConQueso的意思，这里是使用PHPMyAdmin更新视图的全部步骤：
To expand one what CheeseConQueso is saying, here are the entire steps to update a view using PHPMyAdmin:
- 执行以下查询：
SHOW CREATE VIEW your_view_name - 展开选项并选择
- 复制 创建视图列的全部内容。
- 直接运行查询（不含
CREATE VIEW...语法） - 如果您满意，请在左侧列表中点击您的视图以浏览其数据，然后一直滚动到底部您会看到 CREATE VIEW 链接。
- 请在 显示您要更新的视图的名称。
- 在 AS 字段放置测试时运行的查询的内容（不包括
CREATE VIEW ...语法）。 - 按开始
<
- Run the following query:
SHOW CREATE VIEW your_view_name - Expand the options and choose Full Texts
- Press Go
- Copy entire contents of the Create View column.
- Make changes to the query in the editor of your choice
- Run the query directly (without the
CREATE VIEW... syntax) to make sure it runs as you expect it to. - Once you're satisfied, click on your view in the list on the left to browse its data and then scroll all the way to the bottom where you'll see a CREATE VIEW link. Click that.
- Place a check in the OR REPLACE field.
- In the VIEW name put the name of the view you are going to update.
- In the AS field put the contents of the query that you ran while testing (without the
CREATE VIEW...syntax). - Press Go
我希望能帮助别人。特别感谢CheesConQueso他/她的有见地的回答。
I hope that helps somebody. Special thanks to CheesConQueso for his/her insightful answer.
这篇关于如何使用phpMyAdmin 3.2.4编辑视图？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
