∫∫∫

用where1=1连接多个条件 select c.StartAreaID, a1.level as startLevel, a1.areaName as startName1, a2.areaName as startName2, a3.areaName as startName3, a4.areaName as endName1, a5.are...

date_format(ri.editDate,'%Y-%m-%d') as editDatedate_format(g.LoadDate,'%Y-%m-%d %H:%i:%s') as loadDateDATE_FORMAT(NOW(),'%Y-%m-%d %H:%i:%s') 

InnoDB写的性能略高于MyISAM，MyISAM的读的性能远高于InnoDB，如果读的多，建议使用MyISAMMyISAM不支持事务。---------------------------------------------------------------------------------------------------------------------InnoDB...

@JsonFormat(pattern="yyyy-MM-dd HH:mm:ss",timezone = "GMT+8") public Date getRegistDate() { return registDate; } 

select ifnull(d.Name,'') as name,