<insert id="insertSelective" parameterType="cn.gzrrg.mwapi.pojo.BetweenExampleCategory" >
insert into between_example_category
<trim prefix="(" suffix=")" suffixOverrides="," >
<if test="betweenExampleCategoryId != null" >
between_example_category_id,
</if>
<if test="name != null" >
name,
</if>
<if test="type != null" >
type,
</if>
<if test="createTime != null" >
create_time,
</if>
</trim>
trim 标签可以根据需求组织sql,可以代替where标签或者是set标签
prefix:在trim标签内sql语句加上前缀。
suffix:在trim标签内sql语句加上后缀。
prefixOverrides:指定去除多余的前缀内容
suffixOverrides:指定去除多余的后缀内容,如:suffixOverrides=","
去除trim标签内sql语句多余的后缀","