title: How to safely modify a lot of MySQL column comments?
body: <p>In our current database, We have a lot of tables without a comment on the column. We would like to add comments to columns, but</p>
  
  <pre><code> ALTER TABLE `user` CHANGE `id` `id` INT( 11 ) COMMENT 'id of user'  
  </code></pre>
  
  <p>will change the column data schema,too.</p>
  
  <p>We are afraid that with so many changes, a mistake would be made and the data schema would be accidentally altered.</p>
  
  <p>What would be the best way to insert the comments with no change to the data schema ?</p>