MySQL Bugs: #64045: create a comment on a view

Bug #64045	create a comment on a view
Submitted:	17 Jan 2012 9:44	Modified:	17 Jan 2012 10:19
Reporter:	elzo valugi	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: Information schema	Severity:	S4 (Feature request)
Version:	5.6	OS:	Any
Assigned to:		CPU Architecture:	Any
Tags:	comment, VIEW

Description:
CREATE view does not have a COMMENT option like regular tables have although the information schema provides one. The comment is not needed as the type can be retrieved from [TABLE_TYPE] => VIEW, thus duplicating the info.

How to repeat:
SELECT * 
FROM information_schema.tables
WHERE
TABLE_TYPE =  'VIEW'
LIMIT 0 , 30

Shows a TABLE_COMMENT field but it cannot be modified from the default value "VIEW"

Suggested fix:
Alter the CREATE OR REPLACE to include a COMMENT option.

Thank you for the feature request.

Guys, it's been almost 10 years since the first request for this feature.
Is it really so difficult to implement?

(Subscribed to updates on this bug report)

Yes, please implement.  this affects me and my documentation.

It would be nice to have this features. As a DBA, I'm being asked to generate many views and adding comments would be beneficial to many users to have access to our databases,

Please put this feature! Anyone working on this?

Allowing comments to views would prevent me having to have maintain separate documentation for explaining some of the calculated fields I am producing in the view.
I would appreciate this feature being added.
Thanks

I'm also need possibility to document my view just in place!

It would be appreciated :)