I want to know how does one add Comments to Columns of a Table?
I thought it is done this way:
ALTER TABLE compare temp VARCHAR(200) DEFAULT 'Hello' COMMENT 'This is my comment about this column';
But after I created the above sample Column and did DESCRIBE table, the comment is not after that column! Is there a special DESCRIBE for seeing the comments associated with each Column or does one attach a comment to a column in a diff way?
use SHOW CREATE TABLE instead of DESCRIBE