Bug #30729 Add COMMENT attribute to CREATE VIEW

Submitted: 30 Aug 2007 18:27 Modified: 30 Apr 2009 5:42
Reporter: Oliver Smith Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: Views Severity:S4 (Feature request)
Version:5.0+ OS:Any
Assigned to: CPU Architecture:Any
Tags: views comments

[30 Aug 2007 18:27] Oliver Smith
Description:
Views are one of the few MySQL entities that does not allow for a COMMENT attribute in the CREATE statement preventing inline documentation.

How to repeat:
CREATE VIEW v1 COMMENT "Not here" AS SELECT 1 FROM DUAL ;

Suggested fix:
Allow
CREATE VIEW v1 COMMENT "Allowed here" AS SELECT 1 FROM DUAL ;
[31 Aug 2007 12:27] Valeriy Kravchuk
Thank you for a reasonable feature request.
[7 Sep 2007 6:19] Valeriy Kravchuk
Duplicate of bug #15344.
[29 Apr 2009 18:26] John Bercik
Comments should support the syntax here:
 http://dev.mysql.com/doc/refman/5.0/en/comments.html
[30 Apr 2009 5:42] Oliver Smith
That's a different kind of comment, John :)
[18 Dec 2021 13:22] Deborah Davis
Bugs and all opposition is met for the applied forces for the turns. The ting of the https://www.bestbritishwriter.com/review-of-writix/ is assured for the team. Skills are fit for the plucked sources for the notion and all issues for the team work for the filers.
[15 Aug 2022 10:16] Joe Lo
That feature is great, what a shame it missing for years
[20 Feb 2023 7:42] Assignment Writing Services
At <a href="https://assignmentwritingservices.com/">Australia Assignment Help</a>, we take pride in offering excellent academic assignment services. Contact our professionals and enjoy the best assignment services.
[5 Mar 2023 10:46] Scott Chabot
I am really impressed by your article, you have shared such great and useful knowledge here. I would also like to share some useful information about the <a href=https://www.britishgoggles4u.co.uk/product/rectangle-eyeglasses-14/>rectangle eyeglasses</a>...

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.043 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.