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
ctest
change column
i int(11) comment 'just some integer'
... But that doesn't seem to work. Help?
Thanks!
Subject
Written By
Posted
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.