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

show table status;

show full fields from tablename;

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

4、ON DUPLICATE KEY UPDATE 和 IF

 insert into game_activity_progress (id, activity_id, user_pin, uuid, task_count, progress, status, 
finish_tasks, get_time, finish_time, start_time, end_time, modified, created, yn ) 
values (1901, 10002901, 'wenjun00', '10002901wenjun00', '2', 1, 1, '1002,3303', 
'2017-12-20 22:34:53', '2017-12-20 22:44:45', '2017-12-20 16:55:00', '2017-12-23 16:55:00', now(), now(), 1 )
ON DUPLICATE KEY UPDATE 
finish_tasks = IF(status = 1 and progress < task_count and locate(3303, finish_tasks) = 0, 
concat(finish_tasks, ',', 3303), finish_tasks),
progress = IF(status = 1 and progress < task_count and locate(3303, finish_tasks) = 0, 
progress + 1, progress);