创建mysql注释,在mysql中为视图创建注释

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.

解决方案

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

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

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.