MySQL中使用函数时，与后面括号不能之间不能根空格

修改前代码：
select MAX (article_order)
from mall_school_article
where 1=1
and is_deleted = 0
and status = 1
and article_type = #{articleType,jdbcType=TINYINT}

and section = #{section,jdbcType=TINYINT}

报错：FUNCTION dev_operation.MAX does not exist
原因：mysql在使用函数查询时，函数名后面不能加空格

修改后代码：
select MAX(article_order) as
from mall_school_article
where 1=1
and is_deleted = 0
and status = 1
and article_type = #{articleType,jdbcType=TINYINT}

and section = #{section,jdbcType=TINYINT}

转载于:https://www.cnblogs.com/jvjs/p/11294999.html