<sql> 和 <include>
<sql>用来封装SQL语句, <include>来调用。
如:
//sql封装
<sql id="bzjOfficeColumns">
a.id AS "id",
a.proc_ins_id,
a.parent_id AS "parent.id",
a.parent_ids AS "parentIds",
a.name AS "name",
</sql>
//调用
<select id="get" resultType="BzjOffice">
SELECT
<include refid="bzjOfficeColumns"/>
FROM bzj_office a
WHERE a.id = #{id}
</select>
还有就是可以用来多语句一起调用
mybatis 其他标签使用
https://blog.csdn.net/weixin_40950778/article/details/78655288