mybatis写动态sql语句报错:You have an error in your SQL syntax; check the manual that corresponds to your My

一时失言乱红尘 2024-04-18 18:58 44阅读 0赞

Error querying database.  Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '{
                        73
                    ,
                        74
                  ' at line 2
    ### The error may exist in com/shiyaxin/dao/IUserDao.xml

看了好久，这个sql语句！！！(一般都是符号写错，或者有空格，解决办法可以参考)  
错误的:

<select id="findUserInIds" resultType="user" parameterType="queryvo">
            SELECT * FROM `user`
            <where>
                <if test="ids != null and ids.size()>0">
                    <foreach collection="ids" open="and id in {" close= "}" item="uid" separator=",">
                        #{uid}
                    </foreach>
    
                </if>
            </where>
        </select>

正确的: in (" close= “)” 上面错的写是 \{" close= “\}” ，就这里错了

<select id="findUserInIds" resultType="user" parameterType="queryvo">
            SELECT * FROM `user`
            <where>
                <if test="ids != null and ids.size()>0">
                    <foreach collection="ids" open="and id in (" close= ")" item="uid" separator=",">
                        #{uid}
                    </foreach>
    
                </if>
            </where>
        </select>

mybatis写动态sql语句报错:You have an error in your SQL syntax; check the manual that corresponds to your My

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关 You have an error in your SQL syntax； check the manual that corresponds to your MySQL server version

相关 mybatis写动态sql语句报错:You have an error in your SQL syntax; check the manual that corresponds to your My

相关 1064 - You have an error in your SQL syntax； check the manual that corresponds to your MySQL server

相关 mybatis-plus: You have an error in your SQL syntax； check the manual that corresponds to your MySQL

相关 MyBatis中提示：You have an error in your SQL syntax; check the manual that corresponds to your MySQL ser

相关 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version

相关 Mybatis You have an error in your SQL syntax; check the manual that corresponds to your MySQL server

相关 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server versio

相关 You have an error in your SQL syntax； check the manual that corresponds to your MySQL server version

相关 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server versio