title: Create comments for views in mysql
body: <p>I see that the views have a comment field just like the regular tables, but is by default populated with the "VIEW" value. </p>
  
  <pre><code>[TABLE_CATALOG] =&gt; 
  [TABLE_SCHEMA] =&gt; xxx
  [TABLE_NAME] =&gt; view__xxxx
  [TABLE_TYPE] =&gt; VIEW
  [ENGINE] =&gt; 
  [VERSION] =&gt; 
  [ROW_FORMAT] =&gt; 
  [TABLE_ROWS] =&gt; 
  [AVG_ROW_LENGTH] =&gt; 
  [DATA_LENGTH] =&gt; 
  [MAX_DATA_LENGTH] =&gt; 
  [INDEX_LENGTH] =&gt; 
  [DATA_FREE] =&gt; 
  [AUTO_INCREMENT] =&gt; 
  [CREATE_TIME] =&gt; 
  [UPDATE_TIME] =&gt; 
  [CHECK_TIME] =&gt; 
  [TABLE_COLLATION] =&gt; 
  [CHECKSUM] =&gt; 
  [CREATE_OPTIONS] =&gt; 
  [TABLE_COMMENT] =&gt; VIEW
  </code></pre>
  
  <p>When I am trying to create a view with a comment I get an error. </p>
  
  <pre><code>CREATE OR REPLACE VIEW view__x AS
  SELECT 
   * 
  FROM `some_table`  
  COMMENT = 'some comment'
  </code></pre>
  
  <p>Is there a way to modify the comment field or that field is used internally for something else and should stay like it is?</p>
  
  <p>I've added a <a href="http://bugs.mysql.com/bug.php?id=64045">feature request</a> to mysql.</p>