mysql创建视图并加注释_在mysql中为视图创建注释

我看到这些视图具有与常规表格相同的注释字段,但默认情况下使用“VIEW”值.

[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

当我试图创建一个视图与评论我得到一个错误.

CREATE OR REPLACE VIEW view__x AS

SELECT

*

FROM `some_table`

COMMENT = 'some comment'

有没有办法修改注释字段,或者该字段在内部用于别的内容,应该保持原样吗？

我已经添加了一个feature request到mysql.