<sqlid="selectTest">
select
id,
name,
sex,
</sql><selectid="selectStudent"><includerefid="selectTest"/>
age,
address,
from student
where age <![CDATA[>]]> #{minAge}
</select>
# 编译拼接之后语句
select
id,
name,
sex,
age,
address,
from student
where age <![CDATA[>]]> #{minAge}
sql中concat函数用法
即拼接字符串:
SELECT CONCAT(id, name, birthday)as fullname from student