a5601564的博客

BEGINdeclare key_list varchar(255) default ''; declare mykey varchar(255) default ''; declare int_flag int default 0; declare done int default 0; declare count_rs int default 0; declare user_rem...

mysql 两个时间比较 其中一个可能为nullSELECT * FROM (SELECT qi.id,qci.id comment_id,qi.question_time,if(qi.question_time>IFNULL(qci.comment_time,0),qi.question_time,qci.comment_time) newest_timefrom que

#话题SELECT cm.id, cm.cm_alias_name, cm.cm_cover_url ,ifnull(aa.view_num/bb.total,0) view_progress ,aa.view_num ,bb.totalFROM custom_module cmLEFT JOIN ( SELECT bb.cm_id ,uvr.us...