MySQL的sql大于号(小于号)的使用

关注

原创最新推荐文章于 2026-03-15 00:56:39 发布 8.1k 阅读 AI 写同款· GEO 优化 ›

【MySQL用法】MySQL中大于，大于等于，小于，小于等于的转义写法由于在Mybatis框架的xml中，我们常用的大于(>)小于(<)，大于等于（>=）小于等于（<=）解析的时候会经常出问题，导致编译报错，所以就需要对其进行转译才能通过。以下是我整理出来记录在这里方便以后使用，也希望能帮助用到的小伙伴哦~~~ 左边就是原来的符号，右边就是在mybatis中代替的符号原符号 Mybatis中替换的符号备注例子 > > A > B >= &. 阅读详情

MyBatisPlus框架sql书写时,有关大于或小于号的使用,如果不拼接sql(查询时条件拼接)直接>或<即可,如果拼接sql的话,需要使用 > 和<进行比较.示例代码如下:

@Select("<script>" +
"SELECT detail.latoId,IFNULL(detail.classify,'') AS classify,detail.latoId AS maintainId,plan.planNo,detail.machineName," +
"detail.machineId,detail.maintainDate AS planDate,detail.lastMaintainDate,detail.lastMaintenanceContent,detail.maintenanceContent,detail.model " +
" from " + EntityMap.MAINTAIN_INFO + " AS plan" +
" LEFT JOIN " + EntityMap.MAINTAIN_DETAIL + " AS detail ON plan.latoId=detail.formId " +
" LEFT JOIN " + EntityMap.DEVICE_INFO + " AS info ON detail.machineId=info.machineId " +
" where detail.maintainDate < DATE(NOW()) " +
"<if test='time !=null '> AND detail.maintainDate > #{time} </if>" +
"<if test='endTime !=null '> AND detail.endDate BETWEEN detail.endDate AND #{endTime} </if>" +
"<if test='shop !=null '> AND info.department=#{shop} </if>" +
"<if test='classify !=null '> AND detail.classify=#{classify} </if>" +
"<if test='item !=null '> AND detail.maintenanceContent like concat(concat('%',#{item},'%')) </if>" +
" ORDER BY plan.planDate DESC limit #{startRow},#{pageSize}" +
"</script>")