传两个参数order = id asc,order 2 = name desc。。。mapper中语句怎么处理?
select * from user order by
<where>
<if order1 != null>
${order1},
</if>
<if order2!= null>
${order2}
</if>
</where>
这样如果只传id,就会报错,解析是会多个逗号
...全文
6682打赏收藏
MySQL多条件排序
传两个参数order = id asc,order 2 = name desc。。。mapper中语句怎么处理? select * from user order by ${order1}, ${order2} 这样如果只传id,就会报错,解析是会多个逗号