KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
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.
Tags (comma-separated)
Save Edits
Cancel