mysql - Adding comments to all columns of an existing table -

mysql - Adding comments to all columns of an existing table -

please suggest how add together comments columns of existing table in database?

for eg: have table employee columns emp_id, emp_name, emp_salary, emp_address.

now, want add together comments each column of table.

please suggest how accomplish in 1 command.

saw duplicate thread: alter mysql table add together comments on columns

but suggested reply not understood!

query:

alter table employee modify fieldname new_fieldname int(11) comment 'the comment want add', modify fieldname2 new_fieldname2 int(11) comment 'comment seconds row', modify fieldname3 new_fieldname3 int(11) comment 'comment 3rd row';

note have include column definition 1 time again when adding comment.

mysql alter-table