According to the create view syntax there is no way currently to add comment a view:
- https://dev.mysql.com/doc/refman/8.1/en/create-view.html
This feature has been requested several times. There are four active tickets related to this functionality:
- http://bugs.mysql.com/bug.php?id=5159
- http://bugs.mysql.com/bug.php?id=64045
- http://bugs.mysql.com/bug.php?id=52429
- http://bugs.mysql.com/bug.php?id=15344
…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.
Update – I posted this comment in December 2013. At that time version was 5.7. As of August 2023, the latest version is 8.1 and there has been no change to the CREATE VIEW documentation page.