MySQL Forums
Forum List  »  General

how do I set columns.column_comment?
Posted by: mysql
Date: October 10, 2005 09:58AM

How do I set information_schema.columns.column_comment?

When I try to update information_schema.columns.column_comment directly, I get this error:
#1288 - The target table COLUMNS of the UPDATE is not updatable

I know I can add the comment at table creation, but I would like to change it after table creation.

I would think I could do this through ALTER TABLE:

alter table
change column
i int(11) comment 'just some integer'

... But that doesn't seem to work. Help?


Options: ReplyQuote

Written By
how do I set columns.column_comment?
October 10, 2005 09:58AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.