Menu
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.
603
MySQL Server supports three comment styles: From a # character to the end of the line. From a -- sequence to the end of the line. In MySQL, the -- (double-dash) comment style requires the second dash to be followed by at least one whitespace or control character (such as a space, tab, newline, and so on).
This is a type of comment. The /* is the beginning of a comment and */ is the end of comment. MySQL will ignore the above comment.
By default, a new view is created in the default database. To create the view explicitly in a given database, use db_name. view_name syntax to qualify the view name with the database name: CREATE VIEW test.
Multi-line comments start with /* and end with */ . Any text between /* and */ will be ignored.
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:
...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.
94
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
