### Error updating database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You

喜欢ヅ旅行 2022-10-20 13:39 127阅读 0赞

## 解决mybatis-plus插入的坑 ##

### Error updating database.  Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 'order (userEmail,productId,orderId,createTime,money,integral) values ('325359288' at line 1
    ### The error may exist in com/dpj/mapper/ShopMapper.xml
    ### The error may involve com.dpj.mapper.ShopMapper.insertProductOrder-Inline
    ### The error occurred while setting parameters
    ### SQL: INSERT INTO order (userEmail,productId,orderId,createTime,money,integral) values (?,?,?,?,?,?)
    ### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 'order (userEmail,productId,orderId,createTime,money,integral) values ('325359288' at line 1
    ; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 'order (userEmail,productId,orderId,createTime,money,integral) values ('3253598' at line 1] with root cause

原因插入语句出现了与mp的关键字了，这里sql语句没错，错在order这个表的关键词  
改成ordertemp这个表

<insert id="insertProductOrder" parameterType="Order">
        INSERT INTO ordertemp (userEmail,productId,orderId,createTime,money,integral) values (#{usrEmail},#{productId},#{orderId},#{createTime},#{money},#{integral})
    </insert>

### Error updating database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You

发表评论取消回复

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

相关阅读

相关 Error updating database. Cause: java.sql.SQLException: Unknown initial character set index ‘255‘ re

相关 WPScan Error | Updating the Database ...

相关 "org.springframework.dao.DuplicateKeyException: \r\n### Error updating database. Cause

相关达梦数据库：Error updating database. Cause: dm.jdbc.driver.DMException: 数据未找到

相关 Error updating database. Cause: java.sql.SQLSyntaxErrorException: ORA-01745: invalid host/bind vari

相关 ### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL

相关 Error updating database. Cause: java.sql.SQLSyntaxErrorException: ORA-00947: 没有足够的值

相关 Error updating database. Cause: java.sql.SQLException:Lock wait timeout exceeded；try restarting t(☆)

相关 ### Error updating database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You

相关 mybatis报Error updating database. Cause: java.lang.IllegalArgumentException: invalid comparison: java