Adding comments to columns [duplicate]

This question already has answers here: Closed 12 years ago.

Possible Duplicate:

Alter MYSQL Table To Add Comments on Columns

Hi Guys,

I googled all over the place but I can't find the answer. I know you can add comments to your database columns. I already created a table but now i want to add comments to certain columns, my database programma (sequel pro) doesn't have a function to alter the columns with comments.

Is there an 'update' or 'alter' query to add comments to your column开发者_开发技巧s? The database is in mysql.

Thanks!

UPDATE: found this. Now Trying if it's working

---

Just add

COMMENT "comment"

after your

ALTER TABLE xxx CHANGE xxx...