1

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 columns? The database is in mysql.

Thanks!

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

Community
  • 1
  • 1
Tim
  • 9,351
  • 1
  • 32
  • 48

1 Answers1

1

Just add

COMMENT "comment"

after your 

ALTER TABLE xxx CHANGE xxx...
MatTheCat
  • 18,071
  • 6
  • 54
  • 69