title: How to set column's comment with CREATE TABLE and SELECT statement
body: <p>I want to set column's comment with CREATE TABLE and SELECT statement in MySQL(MySQL version is 5.1.69.).<br>
  I try the following query. However column's comment is not set.</p>
  
  <pre><code>CREATE TABLE t (
    parent_id INT(10) NULL COMMENT 'test'
  ) ENGINE=INNODB 
  SELECT 1 AS parent_id;
  
  SHOW FULL COLUMNS FROM t;
  
  +-----------+---------+-----------+------+-----+---------+-------+---------------------------------+---------+
  | Field     | Type    | Collation | Null | Key | Default | Extra | Privileges                      | Comment |
  +-----------+---------+-----------+------+-----+---------+-------+---------------------------------+---------+
  | parent_id | int(10) | NULL      | YES  |     | NULL    |       | select,insert,update,references |         |
  +-----------+---------+-----------+------+-----+---------+-------+---------------------------------+---------+
  1 row in set (0.00 sec)
  </code></pre>
  
  <p>How do I set column's comment with CREATE TABLE and SELECT statement.</p>