mysql 常用语法

 

 转义符　　<![CDATA[     ]]>

<!-- 分页 -->
<sql id="pagerB">
  <if test="pager != null">
    LIMIT #{pager.pageStartIndex,jdbcType=INTEGER},#{pager.pageRows,jdbcType=INTEGER}
  </if>
</sql>

<include refid="pagerB"/>

where语句

<where>
  <trim prefixOverrides="AND">
    <if test="search != null and search != '' ">
      AND search LIKE CONCAT('%',#{search},'%')
    </if>
  </trim>
</where>