add field to mysql with comment code example

Example: mysql add comment to column

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