Sql语句错误：check the manual that corresponds to your MySQL server version for the right syntax to use..

背景 

在做项目的时候，测试写的Sql语句，然后报错如题和下图。

 我起初以为是Sql版本问题

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.nowcoder.community.dao.DiscussPostMapper">
    <sql id="selectFields">
        id,user_id,title,content,type,status,create_time,comment_count,score
    </sql>
    <select id="selectDiscussPosts" resultType="com.nowcoder.community.entity.DiscussPost">
        select <include refid="selectFields"></include>
        from discuss_post
        where status != 2,
        <if test="userId != 0">
            and user_id = #{userId}
        </if>
        order by type desc, create_time desc
        limit #{offset}, #{limit}
    </select>

    <select id="selectDiscussPostRows" resultType="int">
        select count(id)
        from discuss_post
        where status != 2,
        <if test="userId != 0">
            and user_id = #{userId}
        </if>
    </select>
</mapper>

后来才发现是where语句后面随手点了一个 ，逗号。粗心导致

解决办法：

仔细检查标点符号！！！