MySQL插入语句报错：如何解决SQL语法错误“You have an error in your SQL syntax”？

积累知识，胜过积蓄金银！毕竟在文章开发的过程中，会遇到各种各样的问题，往往都是一些细节知识点还没有掌握好而导致的，因此基础知识点的积累是很重要的。下面本文《MySQL插入语句报错：如何解决SQL语法错误“You have an error in your SQL syntax”？》，就带大家讲解一下知识点，若是你对本文感兴趣，或者是想搞懂其中某个知识点，就请你继续往下看吧~

sql insert语法报错

问题：

插入语句一直报错，提示sql语法错误：“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 ')values( 'hello' at line 11”。

调用方法：

public int insertpncode(pnmodelinoutinventory pnmodelinoutinventory) {
    return pnmapperruku.insertpnassertrukudetails(pnmodelinoutinventory);
}

mapper.xml中代码：

<insert id="insertpnassertrukudetails" parametertype="com.ruoyi.system.domain.pnmodelinoutinventory">
    insert into pnassertrukudetails (
        <if test="parentpnassertrukuid != null and parentpnassertrukuid != '' ">parent_pnassertruku_id,</if>
        <if test="materialinformation != null and materialinformation != '' ">materialinformation,</if>
        <if test="numbersruku != null and numbersruku != '' ">numbersruku,</if>
        <if test="qualified != null and qualified != '' ">qualified,</if>
        <if test="unit != null and unit != '' ">unit,</if>
        <if test="storageroom != null and storageroom != ''">storageroom,</if>
        <if test="sn != null and sn != ''">sn,</if>
        <if test="remark != null and remark != ''">remark,</if>
        <if test="batchnumber != null and batchnumber != ''">batchnumber,</if>
    )values(
        <if test="parentpnassertrukuid != null and parentpnassertrukuid != '' ">#{parentpnassertrukuid},</if>
        <if test="materialinformation != null and materialinformation != '' ">#{materialinformation},</if>
        <if test="numbersruku != null and numbersruku != '' ">#{numbersruku},</if>
        <if test="qualified != null and qualified != '' ">#{qualified},</if>
        <if test="unit != null and unit != '' ">#{unit},</if>
        <if test="storageroom != null and storageroom != ''">#{storageroom},</if>
        <if test="sn != null and sn != ''">#{sn},</if>
        <if test="remark != null and remark != ''">#{remark},</if>
        <if test="batchnumber != null and batchnumber != ''">#{batchnumber},</if>
    )
</insert>

问题分析：

错误提示中的“' )values( 'hello'”表明语法错误发生在插入语句中的值列表部分。仔细对比了上述mapper.xml代码，发现各个字段名和参数占位符之间存在多余的逗号。

修改：

移除多余的逗号，如下：

<insert id="insertPnAssertRukuDetails" parameterType="com.ruoyi.system.domain.PnModelInOutInventory">
    insert into pnAssertRukuDetails (
        <if test="parentPnAssertRukuId != null and parentPnAssertRukuId != '' ">parent_pnAssertRuku_id</if>
        <if test="materialInformation != null and materialInformation != '' ">materialInformation</if>
        <if test="numbersRuKu != null and numbersRuKu != '' ">numbersRuKu</if>
        <if test="qualified != null and qualified != '' ">qualified</if>
        <if test="unit != null and unit != '' ">unit</if>
        <if test="storageRoom != null and storageRoom != ''">storageRoom</if>
        <if test="sn != null and sn != ''">sn</if>
        <if test="remark != null and remark != ''">remark</if>
        <if test="batchNumber != null and batchNumber != ''">batchNumber</if>
    )values(
        <if test="parentPnAssertRukuId != null and parentPnAssertRukuId != '' ">#{parentPnAssertRukuId}</if>
        <if test="materialInformation != null and materialInformation != '' ">#{materialInformation}</if>
        <if test="numbersRuKu != null and numbersRuKu != '' ">#{numbersRuKu}</if>
        <if test="qualified != null and qualified != '' ">#{qualified}</if>
        <if test="unit != null and unit != '' ">#{unit}</if>
        <if test="storageRoom != null and storageRoom != ''">#{storageRoom}</if>
        <if test="sn != null and sn != ''">#{sn}</if>
        <if test="remark != null and remark != ''">#{remark}</if>
        <if test="batchNumber != null and batchNumber != ''">#{batchNumber}</if>
    )
</insert>

今天关于《MySQL插入语句报错：如何解决SQL语法错误“You have an error in your SQL syntax”？》的内容介绍就到此结束，如果有什么疑问或者建议，可以在golang学习网公众号下多多回复交流；文中若有不正之处，也希望回复留言以告知！