mybatis之＜trim prefix=““ suffix=““ suffixOverrides=““ prefixOverrides=““＞＜/trim＞的含义

prefix:在trim标签内sql语句加上前缀。
suffix:在trim标签内sql语句加上后缀。
suffixOverrides:指定去除多余的后缀内容，如：suffixOverrides=","，去除trim标签内sql语句多余的后缀","。
prefixOverrides:指定去除多余的前缀内容

insert into fd_program
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="id != null  and id != ''">id,</if>
            <if test="programName != null  and programName != ''">PROGRAM_NAME,</if>
            <if test="programCode != null  and programCode != ''">PROGRAM_CODE,</if>
            <if test="ratioX != null  and ratioX != ''">RATIO_X,</if>
            <if test="ratioY != null  and ratioY != ''">RATIO_Y,</if>
            <if test="timelength != null  and timelength != ''">TIMELENGTH,</if>
            <if test="created != null ">CREATED,</if>
            <if test="createBy != null  and createBy != ''">CREATE_BY,</if>
            <if test="updated != null ">UPDATED,</if>
            <if test="updateBy != null  and updateBy != ''">UPDATE_BY,</if>
            <if test="comments != null  and comments != ''">COMMENTS,</if>
            <if test="tip != null  and tip != ''">TIP,</if>
         </trim>