mysql查询表和列的注释、添加列

show table status;

show full fields from tablename;

alter table game_activity_task add `award_type` tinyint(4) COMMENT '派发类型，0：用户领取,1:自动派发';