Alter MYSQL Table To Add Comments on Columns

Question

I have been checking the MySql Documentation for Alter Table and it does not seem to include a way to Alter a MySQL Table for adding a comment for the columns. Anybody knows how can i do it? thanks

// for table
ALTER TABLE myTable COMMENT 'Hello World'

// for columns
// ???

Answer 1

try:

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