在mysql中为视图创建注释 [英] Create comments for views in mysql

问题描述

我看到视图有一个注释字段就像常规表，但是默认填充VIEW值。

I see that the views have a comment field just like the regular tables, but is by default populated with the "VIEW" value.

[TABLE_CATALOG] => 
[TABLE_SCHEMA] => xxx
[TABLE_NAME] => view__xxxx
[TABLE_TYPE] => VIEW
[ENGINE] => 
[VERSION] => 
[ROW_FORMAT] => 
[TABLE_ROWS] => 
[AVG_ROW_LENGTH] => 
[DATA_LENGTH] => 
[MAX_DATA_LENGTH] => 
[INDEX_LENGTH] => 
[DATA_FREE] => 
[AUTO_INCREMENT] => 
[CREATE_TIME] => 
[UPDATE_TIME] => 
[CHECK_TIME] => 
[TABLE_COLLATION] => 
[CHECKSUM] => 
[CREATE_OPTIONS] => 
[TABLE_COMMENT] => VIEW

当我试图创建一个带注释的视图时，我得到一个错误。

When I am trying to create a view with a comment I get an error.

CREATE OR REPLACE VIEW view__x AS
SELECT 
 * 
FROM `some_table`  
COMMENT = 'some comment'

是否有修改注释字段的方法，用于其他内容，应该保持原样？

Is there a way to modify the comment field or that field is used internally for something else and should stay like it is?

我添加了一个

I've added a feature request to mysql.

推荐答案

根据create view语法，没有办法目前添加评论a视图：

According to the create view syntax there is no way currently to add comment a view:

• http://dev.mysql.com/doc/refman/5.7/en/create-view.html

• http://dev.mysql.com/doc/refman/5.7/en/create-view.html

此功能已被多次请求。有四种与此功能相关的有效门票：

This feature has been requested several times. There are four active tickets related to this functionality:

• http://bugs.mysql.com/bug.php?id=5159


• http://bugs.mysql.com/bug.php?id=64045


• http://bugs.mysql.com/bug.php?id=52429


• http://bugs.mysql.com/bug.php?id=15344

• http://bugs.mysql.com/bug.php?id=5159
• http://bugs.mysql.com/bug.php?id=64045
• http://bugs.mysql.com/bug.php?id=52429
• http://bugs.mysql.com/bug.php?id=15344

...和几个标记为重复的： http://bugs.mysql.com/bug.php?id=19602 ， http：/ /bugs.mysql.com/bug.php?id=19602 ， http：//bugs.mysql .com / bug.php？id = 13109
， http：//bugs.mysql .com / bug.php？id = 14369 ， http://bugs.mysql.com/bug .php？id = 11082
， http://bugs.mysql.com/bug .php？id = 42870 ， http://bugs.mysql.com/bug.php?id = 38137
， http://bugs.mysql.com/bug.php?id = 38137 ， http://bugs.mysql.com/bug.php?id=30729

...and several marked as duplicates: http://bugs.mysql.com/bug.php?id=19602 , http://bugs.mysql.com/bug.php?id=19602 , http://bugs.mysql.com/bug.php?id=13109 , http://bugs.mysql.com/bug.php?id=14369 , http://bugs.mysql.com/bug.php?id=11082 , http://bugs.mysql.com/bug.php?id=42870 , http://bugs.mysql.com/bug.php?id=38137 , http://bugs.mysql.com/bug.php?id=38137 , http://bugs.mysql.com/bug.php?id=30729

如果您对此问题感兴趣，请转到四个活动工单，单击影响我按钮，并添加注释，询问是否有人正在处理此功能。

If you are interested in this issue, go to the four active tickets, click the "affects me" button, and also add a comment, asking if anyone is working on this feature.

这将增加可见性，并增加其实施的可能性。

This will add visibility, and increase the likelyhood of it being implemented.

这篇关于在mysql中为视图创建注释的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！