SELECTm.y,t.m,t.num,t.textFROM(SELECTFROM_UNIXTIME(`tour_addtime`,'%Y')ASy,FROM_UNIXTIME(`tour_addtime`,'%m')ASm,count(`tour_id`)ASnum,FROM_UNIXTIME(`tour_addtime`,'%Y年%m月')A...
建表：DROPTABLEIFEXISTS`cms_block`;CREATETABLE`cms_block`(`id`intUNSIGNEDNOTNULLAUTO_INCREMENTCOMMENT'主键/自增',`title`varchar(100)CHARACTERSETutf8mb4COLLATEutf8mb4_general_ci...
