修改数据库表(比如:your_tablename)的COMMENT:
ALTER TABLE your_tablename COMMENT = '新的内容'
修改数据库表的某列(some_column_name)的COMMENT:
ALTER TABLE your_tablename CHANGE COLUMN some_column_name
some_column_name TYPE COMMENT '新的内容'
比如:
ALTER TABLE YOUR_TABLENAME CHANGE COLUMN some_column_name
some_column_name mediumint(3) COMMENT '新的内容'
显示表和列的COMMENTS:
SHOW CREATE TABLE your_tablename;