mysql command line give comments to column code example

Example 1: mysql add comment to column

ALTER TABLE `user` CHANGE `id` `id` INT( 11 ) COMMENT 'id of user';

Example 2: comments in mysql

#this is a comment
-- this is a comment but requires a whitespace/tab/newline after the double -